deepumi / data.net Goto Github PK

      private const int DefaultCapacity = 4;
      
      public DataParameters() : this(DefaultCapacity) { }

       public DataParameters(int capacity)
        {
            if (capacity <= 0) capacity = DefaultCapacity;

            _parameters = new List<object>(capacity);
        }

public async Task<int> ExecuteNonQueryAsync(string sql, CommandType commandType = CommandType.Text, DataParameters parameters = null, CancellationToken token = default(CancellationToken));

public async Task<T> ExecuteScalarAsync<T>(string sql, CommandType commandType = CommandType.Text, DataParameters parameters = null, CancellationToken token = default(CancellationToken));

public async Task<IDataReader> ExecuteReaderAsync(string sql, CommandType commandType = CommandType.Text,
            DataParameters parameters = null, CommandBehavior behavior = CommandBehavior.CloseConnection, CancellationToken token = default(CancellationToken));

public async Task<T> QuerySingleAsync<T>(string sql, CommandType commandType = CommandType.Text, DataParameters parameters = null,
            CommandBehavior behavior = CommandBehavior.CloseConnection, CancellationToken token = default(CancellationToken));

public Database(IDbConnection connection, bool useTransaction)
public Database(IDbConnection connection, bool useTransaction, IsolationLevel isolationLevel)

public class Location
{
	public string Area { get; set; }
}

using (var db = new Database(new OracleConnection("connecitonString" )))
{
	try
	{
		var x = db.Query<Location>("SELECT 'test' as Area FROM Dual");
	}
	catch (Exception e)
	{
		
	}
}

   at Data.Net.DataRowReader.ReaderToType[T](IDataReader reader) in C:\Projects\Data.Net\Data.Net\DataRowReader.cs:line 32
   at Data.Net.Database.Query[T](String sql, CommandType commandType, DataParameters parameters, CommandBehavior behavior) in C:\Projects\Data.Net\Data.Net\Database.cs:line 127
   at Data.Net.Oracle.Test.Program.Main(String[] args) in C:\Projects\Data.Net\Data.Net.Oracle.Test\Program.cs:line 16

 var p = cmd.CreateParameter();
 p.ParameterName = parameter.Name;
 p.Value = parameter.Value ?? System.DBNull.Value;

 var p = cmd.CreateParameter();
 p.ParameterName = parameter.Name;
 p.Value = parameter.Value;