.NET SQL Server Stored Procedure Data Access Layer
2016-08-23
1 0 0
no vote
Other
Earn points
Translated by maninwest@Codeforge Author:Peter Piotti @ Codeproject
Many developers do all of their data access through stored procedures, either by choice or by mandate. This is a clean, simple alternative to using the Entity Framework for stored procedure data access in a .NET/SQL Server environment.
Background
The SqlServerStoredProcedureDataAccessLayer namespace contains one public class called SqlDatabase.
The methods in the SqlDatabase class are very transparently built upon standard SqlData methods. If you get an exception, it is very easy to debug because these methods do not obfuscate the underlying SqlCommand methods.
The SqlDatabase methods and their underlying SqlData methods are:
Many developers do all of their data access through stored procedures, either by choice or by mandate. This is a clean, simple alternative to using the Entity Framework for stored procedure data access in a .NET/SQL Server environment.
Background
The SqlServerStoredProcedureDataAccessLayer namespace contains one public class called SqlDatabase.
The methods in the SqlDatabase class are very transparently built upon standard SqlData methods. If you get an exception, it is very easy to debug because these methods do not obfuscate the underlying SqlCommand methods.
The SqlDatabase methods and their underlying SqlData methods are:
No comment