All geek questions in one place

Entity Framework with lots (50K +)

I would like to use the Entity Framework for a database with more than 50,000 tables. I want to create objects only on a small part of these tables (less than 10). When I go to add tables using a wizard or server explorer, Visual Studio seems to be unable to process a large number of tables. The tree view seems to be limited to this many elements.

I want to create a mapping manually if this is the only option.

  • Is there a way to “filter” tables to find only the ones I need so that I can drag-n-drop?
  • How to create an object manually and then map it to a physical table?

Note. If LinqToSql somehow works better for this, I am also open to this project. However, I would prefer the Entity Framework.

0
source share
4 answers

Try: create a login in a database that has access to only 10 tables. Then use this login to connect to the database for designer purposes.

+10
source

In this case, I would like to create a new database containing only the tables that you want to add from the large database (creating, of course, exact copies). Use this database to create the edmx file. Now you have an edmx file that contains exactly that part of the database you need. Change the connection string and you are ready.

, ( edmx - xml), , , , , .

+4

Hm EF. , NHibernate.

, VS ​​ . *.edmx .

+1

, Linq to SQL , Linq to SQL 10 , , . , EF.

0
source

Source: https://habr.com/ru/post/1538610/

More articles:


All Articles