public string GetInsertStatementWithoutReturningTheIdentityValue()
{
StringBuilder builder = new StringBuilder("INSERT INTO " + Escape(Name) + " (");
AddReferenceColumnNames(builder);
AddRegularColumnNames(builder);
RemoveLastCommaAndSpaceIfThereAreAnyColumns(builder);
builder.Append(") VALUES (");
AddReferenceColumnParameterNames(builder);
AddRegularColumnParameterNames(builder);
RemoveLastCommaAndSpaceIfThereAreAnyColumns(builder);
builder.Append("); SELECT SCOPE_IDENTITY();");
return builder.ToString();
}