CRUD operation with multiple tables using DAL and BAL (No EF

Question

I was looking for tutorial which implements the raw programming in C# asp.net CRUD operations with multiple tables. My tables will be like below holding the one-to-many and many-to-many relations . I don't want to use Entity Framework but want to use the three tired architecture with separate DAL library and BAL library to perform all operations as below from asp.net mvc web pages. -Performing all studentTutor & Subjects CRUD operations - In creating courses need to select Tutor and Subject from dropdownlist -Provide the other CRUD operations on courses -Finally CRUD operations on the enrollment I DIDN'T FIND ANY TUTORIAL WHICH SHOWS THIS BASIC CRUD OPERATIONS WITHOUT USING EF.

Aarush · Answer

Hi @Ali @Franchi and @Munish None of the solutions fulfills my need of relationship tables as shown above. e.g. 1) In Courses view I need Tutors and Subjects as dropdownlist for data creation (similarly the edit view should be able handle the change in subject and Tutor efficiently via dropdownlist) 2) I need views where i can list all students from particular course or list of courses taken by particular student. I was looking for strongly typed CRUD operations for all these tasks without using the queries and in purely object oriented BAL DAL and Viewmodels . I don't want to use the standard EF library builtin in VS.

Aarush · Answer

Hi ali I have implemented the same way. but I was working a) on razor view in front end (the link you provided is very old material with aspx pages). b) on complex relationship tables (as i have completed the single table CRUD operations). c) with image and file upload features

ali tuncer · Answer

Have you seen this one? 3 tier with Ado.net not EF http://www.onlinebuff.com/article_step-by-step-3-tier-architecture-in-aspnet-using-c-example_45.html

Munesh Sharma · Answer

http://dotnet-munesh.blogspot.in/2015/05/use-business-library-as-modal-in-aspnet.html

Francis · Answer

Try my below blog post where i explained CRUD operation without EF. http://www.aspdotnetchamp.com/2015/12/crud-operation-aspnet-mvc-with-adonet.html