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); }