public override string ToSql()
{
if (_source?.Any() != true)
{
return(null);
}
var insert = _orm.Insert <T1>()
.AsTable(_tableRule).AsType(_table.Type)
.WithConnection(_connection)
.WithTransaction(_transaction)
.NoneParameter(true) as Internal.CommonProvider.InsertProvider <T1>;
insert._source = _source;
var ocdu = new OnConflictDoUpdate <T1>(insert);
ocdu.IgnoreColumns(_table.Columns.Values.Where(a => a.Attribute.CanUpdate == false).Select(a => a.Attribute.Name).ToArray());
if (_table.Columns.Values.Where(a => a.Attribute.IsPrimary == false && a.Attribute.CanUpdate == true).Any() == false)
{
ocdu.DoNothing();
}
var sql = ocdu.ToSql();
_params = insert._params;
return(sql);
}
public override string ToSql()
{
if (_source?.Any() != true)
{
return(null);
}
var sqls = new string[2];
var dbParams = new List <DbParameter>();
var ds = SplitSourceByIdentityValueIsNull(_source);
if (ds.Item1.Any())
{
sqls[0] = getInsertSql(ds.Item1, false);
}
if (ds.Item2.Any())
{
sqls[1] = getInsertSql(ds.Item2, true);
}
_params = dbParams.ToArray();
if (ds.Item2.Any() == false)
{
return(sqls[0]);
}
if (ds.Item1.Any() == false)
{
return(sqls[1]);
}
return(string.Join("\r\n\r\n;\r\n\r\n", sqls));
string getInsertSql(List <T1> data, bool flagInsert)
{
var insert = _orm.Insert <T1>()
.AsTable(_tableRule).AsType(_table.Type)
.WithConnection(_connection)
.WithTransaction(_transaction)
.NoneParameter(true) as Internal.CommonProvider.InsertProvider <T1>;
insert._source = data;
insert._noneParameterFlag = flagInsert ? "cuc" : "cu";
string sql = "";
if (IdentityColumn != null && flagInsert)
{
sql = insert.ToSql();
}
else
{
var ocdu = new OnConflictDoUpdate <T1>(insert.InsertIdentity());
var cols = _table.Columns.Values.Where(a => a.Attribute.IsPrimary == false && a.Attribute.CanUpdate == true && _updateIgnore.ContainsKey(a.Attribute.Name) == false);
ocdu.UpdateColumns(cols.Select(a => a.Attribute.Name).ToArray());
if (_doNothing == true || cols.Any() == false)
{
ocdu.DoNothing();
}
sql = ocdu.ToSql();
}
if (string.IsNullOrEmpty(sql))
{
return(null);
}
if (insert._params?.Any() == true)
{
dbParams.AddRange(insert._params);
}
return(sql);
}
}
