public TEntity Insert(IStorageDbConnection conn, TEntity entityToInsert, IEnumerable <Expression <Func <TEntity, object> > > ignoredFields, AutoIncrementTransformer <TKey, TEntity> atf, IDbTransaction tr)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (entityToInsert == null)
{
throw new ArgumentNullException(nameof(entityToInsert));
}
var result = ConstructInsertSql(entityToInsert, ignoredFields, atf != null);
conn.TextWriter.WriteSql(result.CommandText);
if (atf == null)
{
conn.Execute(result.CommandText, result.Parameters, tr);
}
else
{
var id = (TKey)Convert.ChangeType(conn.QuerySingle(typeof(TKey), result.CommandText, result.Parameters, tr), typeof(TKey), CultureInfo.InvariantCulture);
atf(id, entityToInsert);
}
return(entityToInsert);
}
public void Update(IStorageDbConnection conn, TEntity entityToUpdate, IEnumerable <Expression <Func <TEntity, object> > > updateFields, WhereClauseResult whereClause, IDbTransaction tr)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (entityToUpdate == null)
{
throw new ArgumentNullException(nameof(entityToUpdate));
}
var result = ConstructUpdateSql(entityToUpdate, updateFields, whereClause);
conn.TextWriter.WriteSql(result.CommandText);
conn.Execute(result.CommandText, result.Parameters, tr);
}
public void Delete(IStorageDbConnection conn, WhereClauseResult whereClause, IDbTransaction tr)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (whereClause == null)
{
throw new ArgumentNullException(nameof(whereClause));
}
var result = ConstructDeleteSql(whereClause);
conn.TextWriter.WriteSql(result.CommandText);
conn.Execute(result.CommandText, result.Parameters, tr);
}
public void Delete(IStorageDbConnection conn, Expression <Func <TEntity, object> > id, TKey value, IDbTransaction tr)
{
if (conn == null)
{
throw new ArgumentNullException(nameof(conn));
}
if (id == null)
{
throw new ArgumentNullException(nameof(id));
}
var result = ConstructDeleteSql(id, value);
conn.TextWriter.WriteSql(result.CommandText);
conn.Execute(result.CommandText, result.Parameters, tr);
}