public DbCommand BuildInsertCommand(DbProviderFactoryAdapter provider, object data, object keyData, Core.SQL.OnConflictOption option)
{
Debug.Assert(data != null);
DbCommand command = provider.CreateCommand();
var columnNames = new List<string>();
var valueExpressions = new List<string>();
if(keyData != null)
{
var keyField = EntityDescription.Fields.PrimaryKeyField;
if (keyField != null)
{
columnNames.Add(keyField.Name);
valueExpressions.Add(keyField.SQLPramName);
var pram = provider.CreateParameter(keyField.SQLPramName, keyData);
command.Parameters.Add(pram);
}
else
{
throw new InvalidOperationException("keyData provided but type has no key field");
}
}
foreach (FieldAttribute field in EntityDescription.Fields.GetPersistedFields(false, PersistanceFlags.OnInsert))
{
columnNames.Add(field.Name);
valueExpressions.Add(field.SQLPramName);
object value = field.GetFieldValueOrDefault(data);
DbParameter pram = provider.CreateParameter(field.SQLPramName, value);
command.Parameters.Add(pram);
}
var builder = new SQLInsertCommand
{
TableName = EntityDescription.SourceName,
ConflictOption = option,
ColumnNames = columnNames,
ValueExpressions = valueExpressions
};
command.CommandText = builder.ToString();
return command;
}
protected DbCommand BuildSQLDeleteCommand(DbProviderFactoryAdapter provider, string keyFieldName, object keyValue)
{
Debug.Assert(keyValue != null);
Debug.Assert(!string.IsNullOrEmpty(keyFieldName));
string query = string.Format(@"DELETE FROM {0} WHERE {1} = @keyValue;", EntityDescription.SourceName, keyFieldName);
var command = provider.CreateCommand(query);
command.Parameters.Clear();
command.Parameters.Add(provider.CreateParameter("@keyValue", keyValue));
return command;
}
public DbCommand BuildUpdateCommand(DbProviderFactoryAdapter provider, object data, object keyData, Core.SQL.OnConflictOption option)
{
Debug.Assert(data != null);
Debug.Assert(EntityDescription.Fields.PrimaryKeyField != null);
DbCommand command = provider.CreateCommand();
var columnNames = new List<string>();
var columnExpressions = new List<string>();
foreach (FieldAttribute field in EntityDescription.Fields.GetPersistedFields(true, PersistanceFlags.OnUpdate))
{
columnNames.Add(field.Name);
columnExpressions.Add(field.SQLPramName);
object value = field.GetFieldValueOrDefault(data);
DbParameter pram = provider.CreateParameter(field.SQLPramName, value);
command.Parameters.Add(pram);
}
PrimaryKeyFieldAttribute keyField = EntityDescription.Fields.PrimaryKeyField;
DbParameter p = provider.CreateParameter(keyField.SQLPramName, keyData);
command.Parameters.Add(p);
var where = new WhereClause(keyField.Name + " = " + keyField.SQLPramName);
var expression = new SQLUpdateCommand()
{
TableName = EntityDescription.SourceName,
ColumnNames = columnNames,
ValueExpressions = columnExpressions,
ConflictOption = option,
Where = where
};
command.CommandText = expression.ToString();
return command;
}