advise on using Entity Framework or not.

Question

4.00/5 (1 vote)

See more:

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 9-Mar-11 23:29pm

Vincent Beek

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wild-Programmer · Accepted Answer · 2011-03-09T23:35:00

Solution 1

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 ;)

Posted 9-Mar-11 23:35pm

Wild-Programmer

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?

Wild-Programmer 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

Wild-Programmer 10-Mar-11 6:49am

Thanks Sairam :)

Vincent Beek 14-Mar-11 9:34am

So, back to reading a book...