Beispiel #1
0
 public void ExecuteWithParameters(IGNQueriable query, IEnumerable <IGNParameterValue> args)
 {
     if (query.CanExecute)
     {
         using (var connection = OpenConnection())
         {
             var dbc = PrepareDbCommand(query.ToString(), connection);
             AddParameters(dbc, args);
             dbc.ExecuteNonQuery();
         }
     }
 }
Beispiel #2
0
        public DataTable ReadDataWithParameters(IGNQueriable query, IEnumerable <IGNParameterValue> args)
        {
            DataTable result = null;

            if (query.CanExecute)
            {
                using (var connection = OpenConnection())
                {
                    var dbc = PrepareDbCommand(query.ToString(), connection);
                    AddParameters(dbc, args);
                    using (var dbReader = dbc.ExecuteReader())
                    {
                        result = InitDataTable(dbReader);
                    }
                }
            }
            return(result);
        }