private static SqlDataReader _GetDataReaderByQuery(string connectionString) { SqlDataReader dr; using (DataBroker db = new DataBroker(connectionString)) { dr = db.GetDataReader("Select * from [dbo].[things]"); } return(dr); }
private static SqlDataReader _GetDataReaderBySP(string connectionString) { SqlDataReader reader; using (DataBroker db = new DataBroker(connectionString)) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add(new SqlParameter { ParameterName = "@thingId", Value = "1" }); reader = db.GetDataReader("[dbo].[usp_GetThings]", sqlParams, CommandType.StoredProcedure); } return(reader); }