DB Model for MS SQL Server

Use this library to reduce code for CRUD operations.
Just add reference to this dll and use predefined functionality.

Version: 1.0.0

Compatibility: Microsoft .Net Framework

Constructors
Model()
public Model(string AppSettingName) 
AppSettingName: Conection string name in config file.

Methods
SqlConnection GetConnection()

Insert, Update & Delete Methods
void Insert(SqlCommand cmd)
void Update(SqlCommand cmd)
void Delete(SqlCommand cmd)

Data Retrieval Methods
DataSet GetDataSet(SqlCommand cmd)
DataTable GetDataTable(SqlCommand cmd)
DataRow GetDataRow(SqlCommand cmd)
string GetScaler(SqlCommand cmd)

Leave a Reply

Your email address will not be published. Required fields are marked *