DBAproach 1.0.0

DBAproach

Custom nuget package to handle database connections

Implementation examples in StoreApi https://github.com/dieg0moraes/StoreApi/tree/master/Data

1. Create a DBHandler that implements IDBHandler
2. Implement the methods - Here is an example

public async Task<IEnumerable<T>> Get<T>(ISelectObject<T> selectCommand)    {
                        using(SqlConnection con = new SqlConnection(ConnectionString))
                        {
                            using(SqlCommand cmd = new SqlCommand(selectCommand.SqlCommand,con))
                            {
                                if(con.State == System.Data.ConnectionState.Closed)
                                    await con.OpenAsync();

 selectCommand.SetParameters(cmd);
                            var results = await selectCommand.Map(await cmd.ExecuteReaderAsync());
                            con.Close();
                            return results;
                        }
                    }
                }
        }

Example of implementation of Map<T> in ISelectDBObject<T>

public async Task<IEnumerable<Customer>> Map(SqlDataReader reader)
{

var customer = new List<Customer>();
while(await reader.ReadAsync())
{
	Customer c = new Customer()
	{

		CustomerId = reader["customerId"].ToString(),

		CustomerName = reader["customerName"].ToString(),

		CustomerLastName = 	reader["customerLastName"].ToString(),

		Mail = reader["customerEmail"].ToString()

	};
customer.Add(c);
}
return customer;

}

More detailed example in https://github.com/dieg0moraes/StoreApi/tree/master/Data