OX.DataAccess 2.0.6

OX.DataAccess 2.0.6 Only for MSSQL

Example

public Class DB
{
    private readonly string _connectionStr = null;
    private Data data;

    public DB(string Connectionstr) 
    {
        _connectionStr = Connectionstr;
        data = new Data();
    }
    
    public void New(Person person)
    {            
        var result = data.ExecSp<Response>("dbo.StoredProcedureName",
        data.ToSqlParameters(person),  //every property is converted to an sql parameter
        reader =>
        {
            return new Response
            {
                Code = reader["Code"].ToString(),
                Message = reader["Message"].ToString()
            };
        });
    }

    //Whithout parameters
    public void New(Person person)
    {            
        var result = data.ExecSp<Response>("dbo.StoredProcedureName",
        reader =>
        {
            return new Response
            {
                Code = reader["Code"].ToString(),
                Message = reader["Message"].ToString()
            };
        });
    }

}