public void WriteEqualityCriteria(string column, object value)
{
if (!_hasWhere)
{
_sb.RemoveLastIfEquals(',');
_sb.Append(" where ");
_hasWhere = true;
}
else
{
_sb.Append(" and ");
}
_sb.Append($"{_utils.EscapeIdentifier(column)}=@{_writer.Parameters.CurrentIndex},");
_writer.Parameters.AddValues(value);
}
public static string GetColumnName(this TableInfo info, MemberExpression member, IEscapeIdentifier provider = null)
{
var col = info.Columns.First(d => d.PropertyInfo.Name == member.Member.Name);
return(provider?.EscapeIdentifier(col.Name) ?? col.Name);
}
public static string GetColumnName(this TableInfo info, string property, IEscapeIdentifier provider)
{
var col = info.Columns.First(d => d.PropertyInfo.Name == property);
return(provider.EscapeIdentifier(col.Name));
}
public IBuildUpdateTable <T> Set(string propertyName, object value)
{
_sb.Append($"{_utils.EscapeIdentifier(propertyName)}=@{_writer.Parameters.CurrentIndex},");
_writer.Parameters.AddValues(value);
return(this);
}