protected int Save(string sql, DynamicParameter parameter, CommandType commandType = CommandType.Text)
{
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = sql;
command.CommandType = commandType;
parameter.Handle(command);
return(command.ExecuteNonQuery());
}
}
protected T FetchOne(string sql, DynamicParameter parameter, CommandType commandType = CommandType.Text)
{
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = sql;
command.CommandType = CommandType.Text;
parameter.Handle(command);
using (IDataReader reader = command.ExecuteReader())
{
if (reader.Read())
{
Fetch(reader);
}
return(default(T));
}
}
}
protected List <T> FetchAll(string sql, DynamicParameter parameter, CommandType commandType = CommandType.Text)
{
using (IDbCommand command = connection.CreateCommand())
{
command.CommandText = sql;
command.CommandType = commandType;
if (parameter != null)
{
parameter.Handle(command);
}
using (IDataReader reader = command.ExecuteReader())
{
List <T> list = new List <T>();
while (reader.Read())
{
list.Add(Fetch(reader));
}
return(list);
}
}
}