I have implemented  http://drc.ideablade.com/ApiDocumentation/IdeaBlade.EntityModel~IdeaBlade.EntityModel.IDataSourceKeyResolver.html - IDataSourceKeyResolver  in my Project to handle dynamic connections.

However, it seems that there's some cacheing or storing of value going on here and the next time I initialize the same EntityManager with the same extension, the GetKey method is not firing anymore.

How can I clear the values that might probably stored somewhere, I want the GetKey to be fired every time I initialize  an EntityManager.

Thanks,

Von 

The DataSourceKey caching is actually done on purpose for this very reason that the GetKey is not fired everytime if the extension has been resolved. And unfortunately, it seems that the caching is not accessible publicly. Before I give you a workaround, could you explain your use case for this?

Because I'm validating the assembly that initiates the initialization of the EntityManager.

Only selected assembly should have the right to access the Model, basically for Layering and Security purposes only.

Thanks,

Von

Another, since I'm trying to have a dynamic connection to the database (though it doesn't make sense to an n-tier environment), assuming I have a datasourceextension w/c was resolved already but I want to change the underlying connection string. E.g. if SampleExtension has a connection to VON\SQL2008R2 but i want to change it to VON2\SQL2008R2, how can i do that without defining another the datasourceextension?

Thanks,

Von 

Is it possible for you to only initialize the EntityManager on those selected assemblies? This is so only selected assembly can access the Model and you never have to worry about validating the assembly.

Another, since I'm trying to have a dynamic connection to the database (though it doesn't make sense to an n-tier environment), assuming I have a datasourceextension w/c was resolved already but I want to change the underlying connection string. E.g. if SampleExtension has a connection to VON\SQL2008R2 but i want to change it to VON2\SQL2008R2, how can i do that without defining another the datasourceextension?

Do you mean that you want to change the SampleExtension's connectionString during runtime? If so, I don't believe this is possible. It wouldn't be a good idea either. You have to define another DataSourceExtension or change that SampleExtension's connectionString to point to VON2\SQL2008R2.

- What I'm doing is that I have a class project and a static function that validates the calling assemble and returns an instance of an EntityManager.

E.g. from the calling assembly:

 NorthwindIBEntities context = MyClass.GetNorthwindEntities();

Now, inside my GetNorthwindEntities function, I'm validating the calling assembly, and if it is permitted to have a connection to the database, It will return an instance of the EntityManager with the "Correct" datasourceextension and the calling assembly will have a connection to the database otherwise it can't connect to the database because it doesn't have the correct datasourceextension. 

How can I do the underlined statement in runtime when it is already resolved? Another, what's the drawback of using multiple dynamic datasourceextension? I mean, how about defining different datasourceextension during Application startup? The idea here is to let the user choose his/her server and database to connect to.. Btw., I'm talking about a Windows Form Application in a LAN environment

I'm trying to follow what you're thinking here. If the calling assembly is valid, you will return an EntityManager with the correct extension and all is good. If the calling assembly is invalid, you can have 2 options:

1. Return null in which case, the calling assembly has to handle the logic.

or

2. Return an EntityManager with an invalid DataSourceExtension, in which case, the GetKey method should handle the logic by throwing an exception when a bad extension is encountered.

Does this sound about right?

change that SampleExtension's connectionString to point to VON2\SQL2008R2. How can I do the underlined statement in runtime when it is already resolved?

1. Using tenant db -  http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-custom-datasourcekeyresolver - http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-custom-datasourcekeyresolver

or

2. By defining EdmKey or multiple connectionStrings in your config file -  http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-data-source-extensions - http://drc.ideablade.com/xwiki/bin/view/Documentation/code-sample-data-source-extensions

If you'd like to define your DataSourceExtension programatically during Application start up, you can do so by accessing the IdeaBladeConfig.Instance. Please see  http://drc.ideablade.com/xwiki/bin/view/Documentation/configure-programmatically#HSpecifyingdatabaseconnectionsincode - http://drc.ideablade.com/xwiki/bin/view/Documentation/configure-programmatically#HSpecifyingdatabaseconnectionsincode  for more details.