Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Mar 16, 2009 04:48 PM by ankit.sri
Mar 16, 2009 08:14 AM|LINK
In the TheeBeerHouse project if I created a stored procedure which comprises of 2 tables.
Create Procedure dbo.[EmpDept]
From Emp e, Dept d
In the database we created stored procedure of every table like Get, Insert, Delete etc.
And against each stored procedure we created funtion in .NET like Get(), Insert(Employee e), Delete(id) etc.
My question is that if a stored procudre has 2 tables should I have to create another class for that procedure? Like for
EmpDept procedure I have to create Detail class, Provider Class, Sqlclient provider class, and BLL class. Is this way is right? If yes it means if I have many procedures which
comprises of different tables then I have to create classes again and again.
Suggest me ….
Mar 16, 2009 04:48 PM|LINK
You could use LINQ to SQL Classes