Entity framework database first best practice for managing a DB

asp.net-mvc ef-database-first entity-framework-6

Question

i would like to know if there is someone that can help me find the best way to manage a db with 50 tables that i assume has to be structured in my mvc application as multiple EMDX files for performance but that will have multiple connection strings that i hate.

So let's make a short example: i have a join of 5 tables to create a customer list grid and another 3 tables join for an employee grid.

I created two edmx context files to manage each grid and i have 2 connection strings.

Now, if i haev to create 30 grid will i have to create 30 edmx files and corresponding 30 connection strings?

The question is: is this the best practice for this? duplicating 30 times the connection string that connects to the same db?

Thanks

1
0
10/20/2015 12:45:12 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

I am not sure why you need separate connection string. If you are connecting to same database then one connection string is enough.

Also if i understand correctly you are creating separate edmx file for each grid. This is not correct way of using Entity Framework. You should be using only one EDMX file for a database, 50 tables is not a big number. If you have complex query then i'll suggest to use store procedure and call it via Entity Framework using function import

1
10/20/2015 12:54:48 PM

Related Questions

Use of the Entity Framework with WPF DataBinding best practices

Also, I dont think you need to do a ToList() here. I believe ObservableCollection() takes an IEnumerable which families already is. If you do a ToList, and then pass that to the ObservableCollection, then I think you will loop through all your records twice....familyOC = new ObservableCollection<Family>(families.ToList()); ...Instead, try this, w...
entity-framework wpf
asked by NotDan

Entity validation best practices in ASP.NET MVC and ADO.NET Entity Framework

i am using ASP.NET MVC & ADO.NET Entity Framework in a project. I want to add validation logic to my entities via partial classes. It works similar like shown in the ...NerdDinner.com ASP.NET MVC Application... which is using LINQ2SQL. The main difference is, that i have to use the"OnPropertyChanging" event instead the "OnValidating" like in LINQ2S...
.net asp.net-mvc entity-framework validation
asked by Alexander

master detail / multi table best practice/method Add to Entity Framework

What you are doing now will work just fine....If you would like to avoid doing a database query when assigning ode.Products, then you could use the following alternative:...// substitute your actual qualified entity set name ode.ProductsReference.EntityKey = new EntityKey("MyEntities.ProductsEntitySetName", "Id", 2); ...This is faster, but les...
.net entity-framework linq linq-to-entities
asked by Craig Stuntz

Best Practices In Business Logic With Entity Framework?

It really depends on how to want to expose your repository/data store....Not sure what you mean by "the context will be closed, therefore i cannot do business logic". Do your business logic ...inside... the using statement. Or if your business logic is in a different class, then let's continue. :)...Some people return concrete collections from thei...
asp.net c# entity-framework linq
asked by RPM1984

Entity Framework is the best approach for implementing business logic validation.

My experience:...This works but it is quite lot of work and in case of many entities which must be validated this can be slower. Actually EFv4.1 does this automatically....I don't like this way - it serves only single property changes and doesn't work for complex validation where you need to modify several properties before you get a valid state...
c# entity entity-framework
asked by Ladislav Mrnka

Best practices to perform CRUD operations on Entities (Entity Framework)

In most cases, business objects and data access should be separated. Have a look at the Repository Pattern ...here..., and ...here.... This is probably exactly what you need.
asp.net-mvc c# entity-framework
asked by Dennis Traub

Best practice to lock a record for editing while using entity framework

Not quite sure how to word this question but here it goes. I am working on a project where multiple client applications are accessing one data source through a WCF service. It may not be relevant but the WCF service is utilizing entity framework to access this data source. Whenever a client has queried a record for editing, I would like to preve...
entity-framework sql
asked by James Shaw

Create one to one relationship by using entity framework database first

Creating a 1:1 relationship is not that tricky and certainly not impossible, although it is not a particularly common requirement and in this case I can't see why you would want it? If people are saying this then you are talking to the wrong people. ...Anyhow using SQL queries as you seem to be is not to do with EF, you are just working directly wi...
ef-code-first ef-database-first entity-framework one-to-one
asked by Dave Williams

What is the best practice for multiple "Include"-s in Entity Framework?

Write a single method GetCategoryById and send a list of relationships to include (maybe, but still seems not elegant enough)...Write methods like GetCategoryByIdWithBooks, GetCategoryByIdWithBooksAndBooksPages and GetCategoryByIdWithBooksAndAuthors (not practical)...A combination of these two is currently my approach. ...I... know what properties ...
architecture c# data-access-layer ef-database-first entity-framework
asked by CodeCaster

What is best practice for using Unity with Entity Framework in a MVC 4 application

container.RegisterType<IMyContext, MyContext>( new ContainerControlledLifetimeManager()) ...This is rather bad, it makes a singleton out of your context. This way not only multiple requests share the same context and you risk concurrency issues but also the memory consumption of such shared context grows without control....Rather, you would l...
asp.net-mvc-4 c# dependency-injection entity-framework unity-container
asked by Wiktor Zychla

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow