Large scale databases? RRS feed

  • Question

  • We have been doing some elementary testing with the ADO.NET Entity framework. When using a 100+ table database, model creation and building in Visual Studio 2008 seems to work quite nicely. When using a 700+ table database, the model building (compiling) takes some time, but runs without errors or warnings. But the model building hangs and after an hour's of running time is still not ready. We suspect that maybe there is something in the database structure that causes problems in the model (which is had to find out because there is no indication of a problem), or is it just the number of tables that causes problems?


    Can the framework handle a 1000+ table database (with lots of table joins), or should we evaluate another product? Anyone have any experiences (good or bad) on the subject?



    Tuesday, August 19, 2008 10:48 AM


All replies