public static void Error(this ISqlLog log, Exception ex, string message)
{
message = message ?? DefaultExceptionMsg;
log.LogMessage(message);
ex = ex.InnerException;
while (ex != null)
{
log.LogMessage(ex.Message);
ex = ex.InnerException;
}
log.LogMessage(Environment.NewLine);
}
protected virtual void CreateTables(ISqlLog log, DatabaseScriptEntry script, IDbContext ctx)
{
var cmd = ctx.Connection.CreateCommand();
if (script.SequenceScripts != null && script.SequenceScripts.Length > 0)
{
foreach (var item in script.SequenceScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.SchemaScripts != null && script.SchemaScripts.Length > 0)
{
foreach (var item in script.SchemaScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.TableScripts != null && script.TableScripts.Length > 0)
{
foreach (var item in script.TableScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.PKConstraintScripts != null && script.PKConstraintScripts.Length > 0)
{
foreach (var item in script.PKConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.FKConstraintScripts != null && script.FKConstraintScripts.Length > 0)
{
foreach (var item in script.FKConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.UniquleConstraintScripts != null && script.UniquleConstraintScripts.Length > 0)
{
foreach (var item in script.UniquleConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.CheckConstraintScript != null && script.CheckConstraintScript.Length > 0)
{
foreach (var item in script.CheckConstraintScript)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
}
protected virtual void CreateTables(ISqlLog log, DatabaseScriptEntry script, IDbContext ctx)
{
var cmd = ctx.Connection.CreateCommand();
if (script.SequenceScripts != null && script.SequenceScripts.Length > 0)
{
foreach (var item in script.SequenceScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.SchemaScripts != null && script.SchemaScripts.Length > 0)
{
foreach (var item in script.SchemaScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.TableScripts != null && script.TableScripts.Length > 0)
{
foreach (var item in script.TableScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.PKConstraintScripts != null && script.PKConstraintScripts.Length > 0)
{
foreach (var item in script.PKConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.FKConstraintScripts != null && script.FKConstraintScripts.Length > 0)
{
foreach (var item in script.FKConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.UniquleConstraintScripts != null && script.UniquleConstraintScripts.Length > 0)
{
foreach (var item in script.UniquleConstraintScripts)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
if (script.CheckConstraintScript != null && script.CheckConstraintScript.Length > 0)
{
foreach (var item in script.CheckConstraintScript)
{
cmd.CommandText = item;
log.LogMessage(item);
cmd.ExecuteNonQuery();
}
}
}
IEnumerable <int> ExecuteBatch(string commandText, NamedParameter[] parameters, IEnumerable <object[]> paramSets)
{
DataTable dataTable = new DataTable();
for (int i = 0, n = parameters.Length; i < n; i++)
{
var qp = parameters[i];
dataTable.Columns.Add(qp.Name, NLite.Reflection.TypeHelper.GetNonNullableType(qp.Type));
}
log.LogMessage("-- Start SQL Batching --");
log.LogMessage("");
log.LogCommand(commandText, parameters, null);
foreach (var paramValues in paramSets)
{
dataTable.Rows.Add(paramValues);
log.LogParameters(parameters, paramValues);
log.LogMessage("");
}
var count = dataTable.Rows.Count;
var result = new int[count];
if (count > 0)
{
int n;
try
{
var dataAdapter = this.dbContext.dbConfiguration.DbProviderFactory.CreateDataAdapter();
//dataAdapter.UpdateBatchSize = batchSize;
var cmd = this.GetCommand(commandText, parameters, null);
for (int i = 0, m = parameters.Length; i < m; i++)
{
cmd.Parameters[i].SourceColumn = parameters[i].Name;
}
dataAdapter.InsertCommand = cmd;//系统会根据InsertCommand自动生成相关的DeleteCommand等
dataAdapter.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
n = dataAdapter.Update(dataTable);
}
catch (ConnectionException)
{
throw;
}
catch (DBConcurrencyException)
{
throw;
}
catch (Exception ex)
{
var exceptionContext = new DbExceptionContextInfo
{
Sql = commandText,
SqlException = new PersistenceException(ex.Message, ex),
};
throw ExceptionHelper.Convert(log, exceptionConverter, exceptionContext);
}
for (int i = 0; i < count; i++)
{
result[i] = i < n ? 1 : 0;
}
dataTable.Rows.Clear();
}
log.LogMessage("-- End SQL Batching --");
log.LogMessage("");
return(result);
}