Home

Welcome to the Public.SDK.DataAccess.SQL.DotnetStd.Test wiki! Below please find the sample code for Public.SDK.DataAccess.SQL.DotnetStd

//For MySQL db
using (Public.SDK.Database.MySQLDB db = new MySQLDB("[your conection string]"))
{
    string sql = "SELECT * FROM sandbox.Staffs";

    var ds = db.ExecuteDataSet(sql, CommandType.Text);
    var ds2 = db.ExecuteDataSet("[your procedure]", CommandType.StoredProcedure,new MySqlParameter("@param1","value1"),new MySqlParameter("@param2","value2"));
    db.ExecuteNonQuery("[sql]", CommandType.Text);
}

//For Ms SQL server db
using (Public.SDK.Database.MSSQLDB db = new MSSQLDB("[your conection string]"))
{
    string sql = "SELECT * FROM sandbox.Staffs";

    var ds = db.ExecuteDataSet(sql, CommandType.Text);
    var ds2 = db.ExecuteDataSet("[your procedure]", CommandType.StoredProcedure, new MySqlParameter("@param1", "value1"), new MySqlParameter("@param2", "value2"));
    db.ExecuteNonQuery("[sql]", CommandType.Text);
}