/// <summary>
/// Inserts a new object into the database.
/// </summary>
/// <param name="metaTable">TableMatadata from which the object is created</param>
public int Create(TableMetadata metaTable)
{
//collection of queries which will be executed
List <ExecutionQuery> listQueries = null;
int resultCounter = 0;
DatabaseField field = metaTable.GetPrimaryKeyField();
SqlGenerator generator = new SqlGenerator();
ExecutionEngine exec = null;
try
{
listQueries = new List <ExecutionQuery>();
//get the attached tabels
TableMetadata[] attachedData = metaTable.AttachedData;
//check if the table has attached tables.
//If not generate the insert only for a single table.
if (attachedData.Length == 0)
{
//generate the sql command
ExecutionQuery insertQuery = generator.GenerateInsertQuery(database, metaTable);
//add PK constraint if necessary
if (field.isValueAutogenerated)
{
insertQuery.Query = ConstraintManager.GeneratePrimaryKeyConstraint(field.fieldName, metaTable.TableName, insertQuery.Query);
}
listQueries.Add(insertQuery);
}
else
{
//generate the multiple table's insert.
List <ExecutionQuery> multipleQueries = generator.GenerateMultipleInsertQueries(database, metaTable);
// containsSpecialModifications = true;
//add the queries to the
foreach (ExecutionQuery var in multipleQueries)
{
listQueries.Add(var);
}
}
//run in the current session
if (contextSession != null)
{
//the context is in a transaction so just cache the inserts.
if (contextSession.IsInTransaction)
{
foreach (ExecutionQuery var in listQueries)
{
contextSession.Queries.Add(var);
}
}
else
{
resultCounter = execEngine.ExecuteNonQuery(listQueries);
}
}
else
{
//
BeforeExecutingQueries(Operation.Create, ref listQueries);
exec = new ExecutionEngine();
//check if we need the PK or not
if (field.isValueAutogenerated && listQueries.Count == 1)
{
List <object> listPrimaryKeysValues = new List <object>();
resultCounter = exec.ExecuteNonQuery(listQueries, Configuration.DefaultTransactionIsolationLevel, out listPrimaryKeysValues);
if (listPrimaryKeysValues.Count > 0)
{
metaTable.SetFieldValue(field.fieldName, listPrimaryKeysValues[0]);
}
}
else
{
resultCounter = exec.ExecuteNonQuery(listQueries, Configuration.DefaultTransactionIsolationLevel);
}
}
return(resultCounter);
}
finally
{
if (exec != null)
{
exec.Dispose();
}
}
}
