public string CreateDeleteStatement(DatabaseObject databaseObject)
{
var tableName = databaseObject.GetTableName();
var primaryKey = databaseObject.GetPrimaryKey();
return(string.Format("DELETE FROM {0} WHERE {1}",
tableName,
SqlQueryFactoryUtility.CreateEqualityClause(primaryKey, databaseObject.GetDatabaseFields()[primaryKey])));
}
public string CreateSelectCountStatementWithId(DatabaseObject databaseObject)
{
var tableName = databaseObject.GetTableName();
var primaryKey = databaseObject.GetPrimaryKey();
return(string.Format("SELECT COUNT(*) FROM {0} WHERE {1}",
tableName,
SqlQueryFactoryUtility.CreateEqualityClause(primaryKey, databaseObject.GetDatabaseFields()[primaryKey])));
}
public string CreateUpdateStatement(DatabaseObject databaseObject)
{
var tableName = databaseObject.GetTableName();
var primaryKey = databaseObject.GetPrimaryKey();
return(string.Format("UPDATE {0} SET {1} WHERE {2}",
tableName,
SqlQueryFactoryUtility.CreateUpdateList(databaseObject.GetDatabaseFields()),
SqlQueryFactoryUtility.CreateEqualityClause(primaryKey, databaseObject.GetDatabaseFields()[primaryKey])));
}