Last post Jun 16, 2015 10:39 AM by fahidhasan
May 19, 2015 12:11 AM|simonSM|LINK
I would like to developed Web API using entity framework. Database First scenario and calling stored procedures rather than linq queries.
Is there any book outhere? I can't find. Or some learning course or something?
May 20, 2015 03:22 AM|Krunal Parekh|LINK
Please see below articles.
step-by-step walkthrough provide an introduction to Database First development using Entity Framework.
Database First Approach
This step-by-step walkthrough show how to use the Entity Framework Designer (EF Designer) to import stored procedures into a model and then call the imported stored procedures to retrieve results.
EF Designer Query Sprocs
Using Web API 2 with Entity Framework 6
The above article is using code first but you can change it to database first by the article described above. if you don't want to use linq queries then you will need to create a store procedure for each of the actions and then just pass the parameters to
the auto generated method in the model to call the store procedure.
Hope this helps.
Jun 15, 2015 10:47 AM|simonSM|LINK
Thank you Krunal.
Do you maybe know also for some good book or resource for ASP.NET MVC with entity framework (if possible db first)?
Jun 16, 2015 01:47 AM|Krunal Parekh|LINK
You can find recommended books here. http://www.asp.net/mvc/books
Jun 16, 2015 10:39 AM|fahidhasan|LINK
thank you everyone...