private static DataTable _GetDataTableByQuery(string connectionString) { DataTable dt; using (DataBroker db = new DataBroker(connectionString)) { dt = db.GetDataTable("Select * from [dbo].[things]"); } return(dt); }
private static DataTable _GetDataTableBySP(string connectionString) { DataTable dt; using (DataBroker db = new DataBroker(connectionString)) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter { ParameterName = "@thingId", Value = "1" }); dt = db.GetDataTable("[dbo].[usp_GetThings]", sqlParams, CommandType.StoredProcedure); } return(dt); }