akohan
asked on
Using ADO.NET instead of Entity Framework
Hello,
I'm new to MVC 4 and currently have got the idea how it works and about to start a new project however, I do not see any need of using EF or Entity Framework so instead want to use ADO.NET
Can somebody give me the idea how that can be done? do I need to create a class and then use it anytime I need?
Is there any a step by step example on how to use ADO.NET rather EF?
Thanks,
ak
I'm new to MVC 4 and currently have got the idea how it works and about to start a new project however, I do not see any need of using EF or Entity Framework so instead want to use ADO.NET
Can somebody give me the idea how that can be done? do I need to create a class and then use it anytime I need?
Is there any a step by step example on how to use ADO.NET rather EF?
Thanks,
ak
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hello guru_sami,
Thank you for the direction. One last question, do you know any article or blog that can walk me through steps? I would love to start with a sample app to see how things gets hooked up logically.
I did google for few keywords and found:
http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET
http://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners
Thanks,
ak
Thank you for the direction. One last question, do you know any article or blog that can walk me through steps? I would love to start with a sample app to see how things gets hooked up logically.
I did google for few keywords and found:
http://www.codeproject.com/Articles/361579/A-Beginners-Tutorial-for-Understanding-ADO-NET
http://www.codeproject.com/Articles/8477/Using-ADO-NET-for-beginners
Thanks,
ak
This is kind of old blog series with asp.net 2.0 WebForms but other than the Presentation all the other stuff is still relevant.
http://imar.spaanjaars.com/416/building-layered-web-applications-with-microsoft-aspnet-20-part-1
http://imar.spaanjaars.com/416/building-layered-web-applications-with-microsoft-aspnet-20-part-1
ASKER
Thank you so much!
ASKER
Great help! thanks for sharing the URL.
You can get an intro to using the SqlConnection and SqlDataReader objects to query a database here
How you structure your code is entirely up to you. But some sort of data access class that you can reuse would be a good start.