Click here to Skip to main content
14,732,999 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
For a new to develop desktop application we have to make some choices.
I wonder if Entity Framework is the way to go.
Please share your vision on this with me.

Some background info:

New windows app supporting MySQL or PostgreSQL. C#, 4.0, WPF.

Database I estimate will be 20-30 tables big. Not impressive in the relationships between tables, a few lookups some 1-many’s that's it.
Some tables will hold 100.000+ records.

It is expected that in the future the data model will not change very frequently but
new functionality based on the same data will be implemented all the time.
This functionality is expected to hold calculations/computations on data and have to be done real-time. Think in terms of ‘average sales/ last months averages sales of sale people from Denver.’



So is Entity Framework a good way to go or something else maybe?
Posted

1 solution

Entity framework is the best thing to work with. It is very powerful in itself, following RDBMS and taking care of cardinalities, constraints and validations. It generates entity classes and everything you need for getting started with DB development.

Best part is using the Entity framework you need not worry about how to do things. you need to concentrate on what to do.

Microsoft is truly living to its moto - Your potential, our passion ;)
   
Comments
Vincent Beek 10-Mar-11 5:40am
   
On some website I read (but usually older pages) that it's not matured yet and buggy.
Do I need to worry about this?
Amit Kumar Tiwari 10-Mar-11 6:51am
   
I dont think so. I personally like it very much. Bug is a bling of software. Dont worry about it until it bothers you.
sairam.bhat 10-Mar-11 5:42am
   
good answer
Amit Kumar Tiwari 10-Mar-11 6:49am
   
Thanks Sairam :)
Vincent Beek 14-Mar-11 9:34am
   
So, back to reading a book...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900