C# (CSharp) XGENO.DBMapper MultiReader Examples

Example #1

        public static List <T> SPQuery <T>(this SqlConnection _dbConn, string _sqlString, params SqlParameter [] _params)
        {
            List <T> _lstObjects;

            using (MultiReader _multiReader = _dbConn.SPMultiQuery(_sqlString, _params))
            {
                _lstObjects = _multiReader.Read <T>();
            }

            return(_lstObjects);
        }

Example #2

 public static void SPNonQuery(this SqlConnection _dbConn, string _sqlString, params SqlParameter[] _params)
 {
     using (MultiReader _multiReader = _dbConn.SPMultiQuery(_sqlString, _params))
     {
     }
 }

Example #3

        public static MultiReader SPMultiQuery(this SqlConnection _dbConn, string _sqlString, params SqlParameter [] _params)
        {
            MultiReader _multiReader = new MultiReader(DBHelper.GetDataSet(_dbConn, _sqlString, true, _params));

            return(_multiReader);
        }