private SqlCommand GetSqlCommand(DatabaseCommandInfo data, SqlConnection sqlConnection) { var cmd = new SqlCommand(data.StoredProcName, sqlConnection) { CommandType = data.CommandType }; if (data.Parameters != null) { cmd.Parameters.AddRange(data.Parameters); } return(cmd); }
public void ExecuteNonQuery(DatabaseCommandInfo data) { using (var con = new SqlConnection(connectionString)) { con.Open(); using (var cmd = new SqlCommand(data.StoredProcName, con)) { cmd.CommandType = data.CommandType; cmd.Parameters.AddRange(data.Parameters); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } } }
public DataTable GetDataTable(DatabaseCommandInfo data) { var dt = new DataTable(); using (var con = new SqlConnection(connectionString)) { con.Open(); using (var cmd = GetSqlCommand(data, con)) { using (var rdr = cmd.ExecuteReader()) { dt.Load(rdr); } cmd.Parameters.Clear(); } } return(dt); }
public DataSet GetDataSet(DatabaseCommandInfo data) { var ds = new DataSet(); using (var con = new SqlConnection(connectionString)) { con.Open(); using (var cmd = GetSqlCommand(data, con)) { using (var rdr = cmd.ExecuteReader()) { ds.Load(rdr, data.Option, data.TableNames); } cmd.Parameters.Clear(); } } return(ds); }