Using entity framework on multiple databases

by

It is very simple. I have:

public WMSEntities() : base("name=WMSEntities") //WMSEntities is conection string name in     web.config also the name of Entitiframework
{
}

already in autogenerated Model.Context.cs of edmx folder

To connect to multiple database in runtime, I created another constructor that takes connection string as parameter like below in same file Model.Context.cs 

public WMSEntities(string connStringName)
    : base("name=" + connStringName)
{
}

Now I added other connection string in Web.Config for example

<add name="WMSEntities31" connectionString="data source=TESTDBSERVER_NAME;initial catalog=TESTDB;userid=TestUser;password=TestUserPW/>

<add name="WMSEntities" connectionString="data source=TESTDBSERVER_NAME12;initial catalog=TESTDB12;userid=TestUser12;password=TestUserPW12/>

Then, when connecting to database I call below method passing connetionString name as parameter

public static List<v_POVendor> GetPOVendorList(string connectionStringName)
{
    using (WMSEntities db = new WMSEntities(connectionStringName))
    {               
        vendorList = db.v_POVendor.ToList();                 
    }
}

More Related Contents:

  1. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  2. Like Operator in Entity Framework?
  3. How can I query for null values in entity framework?
  4. .NET Entity Framework and transactions
  5. Get Database Table Name from Entity Framework MetaData
  6. Can you use Microsoft Entity Framework with Oracle? [closed]
  7. “Items collection must be empty before using ItemsSource.”
  8. Undo changes in entity framework entities
  9. Update primary key value using entity framework
  10. ASP.NET MVC: Is Controller created for every request?
  11. EF LINQ include multiple and nested entities
  12. Cannot attach the file *.mdf as database
  13. Is is possible to check if an object is already attached to a data context in Entity Framework?
  14. Generate POCO classes in different project to the project with Entity Framework model
  15. How to work with Enums in Entity Framework?
  16. What are Navigation Properties in Entity Framework for?
  17. LINQ to Entities does not recognize the method Int32 get_Item(Int32)
  18. How to set default value for POCO’s in EF CF?
  19. How to map table splitting in EF Code First?
  20. Start a Task in the Form Shown event
  21. Organizationally, where should I put common queries when using Entity Framework Code First?
  22. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  23. entity framework Unable to load the specified metadata resource [duplicate]
  24. How to store images using Entity Framework Code First CTP 5?
  25. Do you think it’s advantageous to switch to Entity Framework? [closed]
  26. Model First with DbContext, Fails to initialize new DataBase
  27. Validate data using DataAnnotations with WPF & Entity Framework?
  28. Getting exact error type in from DbValidationException
  29. Using Entity Framework entities as business objects?
  30. Entity framework 4.3 run migrations at application start

Leave a Comment