public static void Delete <T>(string connectionString, T entity) where T : new()
{
var(condition, wheres) = KeyAttribute.GetKeysQueryWhere(entity);
var deleteQueryBuilder = new DeleteQueryBuilder()
.WithWhere(condition, wheres.ToArray());
var query = deleteQueryBuilder.Build <T>();
DataBaseDataReader.ExecuteNonQuery(connectionString, query);
}
private static void Update <T>(string connectionString, T entity, Dictionary <string, object> fieldsWithValues) where T : new()
{
var(condition, wheres) = KeyAttribute.GetKeysQueryWhere(entity);
var updateBuilder = new UpdateQueryBuilder()
.WithFields(fieldsWithValues)
.WithWhere(condition, wheres.ToArray());
var query = updateBuilder.Build <T>();
DataBaseDataReader.ExecuteNonQuery(connectionString, query);
}
