internal static string GenerateDeleteSql(DbDeleteCommandTree tree, EFOracleProviderManifest providerManifest, EFOracleVersion sqlVersion, out List <OracleParameter> parameters)
{
StringBuilder commandText = new StringBuilder(256);
DmlSqlGenerator.ExpressionTranslator expressionTranslator = new DmlSqlGenerator.ExpressionTranslator(commandText, (DbModificationCommandTree)tree, false, sqlVersion);
commandText.Append("delete ");
tree.Target.Expression.Accept((DbExpressionVisitor)expressionTranslator);
commandText.AppendLine();
commandText.Append("where ");
tree.Predicate.Accept((DbExpressionVisitor)expressionTranslator);
parameters = expressionTranslator.Parameters;
return(commandText.ToString());
}
internal static string GenerateInsertSql(DbInsertCommandTree tree, EFOracleProviderManifest providerManifest, EFOracleVersion sqlVersion, out List <OracleParameter> parameters)
{
StringBuilder commandText = new StringBuilder(256);
DmlSqlGenerator.ExpressionTranslator translator = new DmlSqlGenerator.ExpressionTranslator(commandText, (DbModificationCommandTree)tree, null != tree.Returning, sqlVersion);
commandText.Append("insert into ");
tree.Target.Expression.Accept((DbExpressionVisitor)translator);
if (0 < tree.SetClauses.Count)
{
commandText.Append("(");
bool flag1 = true;
foreach (DbSetClause setClause in (IEnumerable <DbModificationClause>)tree.SetClauses)
{
if (flag1)
{
flag1 = false;
}
else
{
commandText.Append(", ");
}
setClause.Property.Accept((DbExpressionVisitor)translator);
}
commandText.AppendLine(")");
bool flag2 = true;
commandText.Append("values (");
foreach (DbSetClause setClause in (IEnumerable <DbModificationClause>)tree.SetClauses)
{
if (flag2)
{
flag2 = false;
}
else
{
commandText.Append(", ");
}
setClause.Value.Accept((DbExpressionVisitor)translator);
translator.RegisterMemberValue(setClause.Property, setClause.Value);
}
commandText.AppendLine(")");
}
else
{
commandText.AppendLine().AppendLine(" values (default)");
}
DmlSqlGenerator.GenerateReturningSql(commandText, (DbModificationCommandTree)tree, translator, tree.Returning, providerManifest, sqlVersion, false);
parameters = translator.Parameters;
return(commandText.ToString());
}
internal static string GenerateUpdateSql(DbUpdateCommandTree tree, EFOracleProviderManifest providerManifest, EFOracleVersion sqlVersion, out List <OracleParameter> parameters)
{
StringBuilder commandText = new StringBuilder(256);
DmlSqlGenerator.ExpressionTranslator translator = new DmlSqlGenerator.ExpressionTranslator(commandText, (DbModificationCommandTree)tree, null != tree.Returning, sqlVersion);
int count = tree.SetClauses.Count;
commandText.Append("update ");
tree.Target.Expression.Accept((DbExpressionVisitor)translator);
commandText.AppendLine();
bool flag = true;
commandText.Append("set ");
foreach (DbSetClause setClause in (IEnumerable <DbModificationClause>)tree.SetClauses)
{
if (flag)
{
flag = false;
}
else
{
commandText.Append(", ");
}
setClause.Property.Accept((DbExpressionVisitor)translator);
commandText.Append(" = ");
setClause.Value.Accept((DbExpressionVisitor)translator);
}
if (flag)
{
commandText.Append("[place_holder] ");
}
commandText.AppendLine();
commandText.Append("where ");
tree.Predicate.Accept((DbExpressionVisitor)translator);
if (flag)
{
string str = commandText.ToString();
int num = str.IndexOf("where ");
string newValue = str.Substring(num + "where ".Length).Replace("(", "").Replace(")", "").Replace(" and ", " ,");
commandText.Replace("[place_holder]", newValue);
}
commandText.AppendLine();
DmlSqlGenerator.GenerateReturningSql(commandText, (DbModificationCommandTree)tree, translator, tree.Returning, providerManifest, sqlVersion, true);
parameters = translator.Parameters;
return(commandText.ToString());
}
private static void GenerateReturningSql(StringBuilder commandText, DbModificationCommandTree tree, DmlSqlGenerator.ExpressionTranslator translator, DbExpression returning, EFOracleProviderManifest providerManifest, EFOracleVersion sqlVersion, bool isUpdate)
{
if (returning == null)
{
return;
}
EntitySetBase target = ((DbScanExpression)tree.Target.Expression).Target;
StringBuilder stringBuilder = new StringBuilder(50);
stringBuilder.Append("declare\n");
Dictionary <EdmMember, string> dictionary = new Dictionary <EdmMember, string>();
foreach (EdmMember member in target.ElementType.Members)
{
ReadOnlyMetadataCollection <Facet> facets = ((TypeUsage)member.MetadataProperties["TypeUsage"].Value).Facets;
string empty = string.Empty;
if (facets.Contains("StoreGeneratedPattern"))
{
string str = facets["StoreGeneratedPattern"].Value.ToString();
if (!string.IsNullOrEmpty(str))
{
if (isUpdate && str.ToUpperInvariant() == "COMPUTED")
{
dictionary[member] = str;
}
else if (!isUpdate && (str.ToUpperInvariant() == "COMPUTED" || str.ToUpperInvariant() == "IDENTITY"))
{
dictionary[member] = str;
}
}
}
if (dictionary.ContainsKey(member))
{
stringBuilder.Append(DmlSqlGenerator.GenerateMemberTSql(member));
stringBuilder.Append(" ");
stringBuilder.Append(SqlGenerator.GetSqlPrimitiveType((DbProviderManifest)providerManifest, sqlVersion, member.TypeUsage));
stringBuilder.Append(";\n");
}
}
stringBuilder.Append("begin\n");
commandText.Insert(0, stringBuilder.ToString());
OracleParameter parameter = translator.CreateParameter(OracleDbType.RefCursor, ParameterDirection.Output);
commandText.Append("returning\n");
string str1 = string.Empty;
foreach (EdmMember member in target.ElementType.Members)
{
if (dictionary.ContainsKey(member))
{
commandText.Append(str1);
commandText.Append(DmlSqlGenerator.GenerateMemberTSql(member));
str1 = ", ";
}
}
commandText.Append(" into\n");
string str2 = string.Empty;
foreach (EdmMember member in target.ElementType.Members)
{
if (dictionary.ContainsKey(member))
{
commandText.Append(str2);
commandText.Append(DmlSqlGenerator.GenerateMemberTSql(member));
str2 = ", ";
}
}
commandText.Append(";\n");
commandText.Append("open ");
commandText.Append(parameter.ParameterName);
commandText.Append(" for select\n");
string str3 = string.Empty;
foreach (EdmMember member in target.ElementType.Members)
{
if (dictionary.ContainsKey(member))
{
commandText.Append(str3);
commandText.Append(DmlSqlGenerator.GenerateMemberTSql(member));
commandText.Append(" as ");
commandText.Append(DmlSqlGenerator.GenerateMemberTSql(member));
str3 = ", ";
}
}
commandText.Append(" from dual;\n");
commandText.Append("end;");
}