Menu
For a basic ERP (DB with around 150 tables, WinForm app) which would run on a classic LAN network (1 server and up to 25 clients) would you recomend EF4 or DataSet ?
LINQ2SQL is NOT an option !
731
Keep using EF6 if the data access code is stable and not likely to evolve or need new features. Port to EF Core if the data access code is evolving or if the app needs new features only available in EF Core. Porting to EF Core is also often done for performance.
A dataset is a container of multiple DataTable Objects and every data table can have a relationship among them. We can access the data source and fill the dataset with the help of data providers. The . NET Framework provides us with three different types of data providers – ADO.NET, OLEDB, and ODBC.
The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, such as customers and customer addresses, without having to concern themselves with the underlying database tables and columns where this data is stored.
Entity Framework (EF) Core, Microsoft's object-to-database mapper library for . NET Framework, brings performance improvements for data updates in version 7, Microsoft claims. The performance of SaveChanges method in EF7 is up to 74% faster than in EF6, in some scenarios.
EF4. DataSet is an old technology, EF is in many ways a reaction to the problems with datasets.
We recently built an app, where part of it was CRUD operations on 80 Tables. Before EF we would have used Enterprise Library and DataSets. We would have estimated 1 hour per table for writing the CRUD operation and the unit test. With EF this was replaced mostly with autogenerated code.
152
You can choose EF based on the application logic, EF can give you more options but I think we can't decide based on number of tables.
Check this article which will help you to decide:
Why use the Entity Framework?
Also check this nice video: Data Development GPS: Guidance for Choosing the Right Data Access Technology for Your Application Today
36
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
