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

Guest User

10y2.6k.NET

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 student,Tutor & 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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User10y ago
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.
0
Munesh Sharma10y ago
http://dotnet-munesh.blogspot.in/2015/05/use-business-library-as-modal-in-aspnet.html
-1
Francis Susaimichael10y ago
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
-1
Guest User10y ago
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
0
ali tuncer10y ago
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

0