Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

entity framework database Expand / Collapse
Posted Monday, March 18, 2013 5:38 PM


Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:45 PM
Points: 2,015, Visits: 3,809
We are going to develop a new .net application that we think we may use entity framework model.
And as I understand it can generate code like insert, update but not use stored procedures.

Can anyone recommend articles or tutorial of how to develop the model and also database development cycle.
and pros and cons by using insert, update in code in this model instead of using stored procedures

Post #1432409
Posted Monday, March 18, 2013 6:16 PM



Group: Administrators
Last Login: Yesterday @ 8:38 AM
Points: 34,366, Visits: 18,586
You absolutely can use stored procedures:

Personally I'd recommend building a good data model and database first, then point EF at it. However I'd search around for what other people have done as well and make an educated decision for your environment and goals.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1432419
Posted Monday, March 18, 2013 8:23 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 10:29 PM
Points: 319, Visits: 3,453
We found a full EF was way overkill for what we wanted.
We decided to go for a lightweight alternative in PetaPoco.
Before you go down the EF route make sure it is something that you really do require.

How we use it is basically create the webservices and point them to stored procs for all the CRUD (create read update delete) operations - works quite well.
Post #1432438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse