private string GetUpdateStatement(TypeSchema entityInfo, out List <PropertyInfo> fieldPropertyList)
{
fieldPropertyList = new List <PropertyInfo>();
string sets = "";
string query = "";
foreach (SchemaItem mfi in entityInfo.GetKeyFieldInfos())
{
if (query != "")
{
query += " AND ";
}
query += GetQuotedName(mfi.MappingFieldAttribute.FieldName) + "=@" + mfi.ProInfo.Name;
fieldPropertyList.Add(mfi.ProInfo);
}
foreach (SchemaItem mfi in entityInfo.GetNeedUpdateFieldInfos())
{
if (sets != "")
{
sets += ",";
}
sets += GetQuotedName(mfi.MappingFieldAttribute.FieldName) + "=@" + mfi.ProInfo.Name;
fieldPropertyList.Add(mfi.ProInfo);
}
return(string.Format("{0} WHERE {1}", sets, query));
}
private string GetUpdateStatement(TypeSchema entityInfo,out List<PropertyInfo> fieldPropertyList)
{
fieldPropertyList = new List<PropertyInfo>();
string sets = "";
string query = "";
foreach (SchemaItem mfi in entityInfo.GetKeyFieldInfos())
{
if (query != "") query += " AND ";
query += GetQuotedName(mfi.MappingFieldAttribute.FieldName) + "=@" + mfi.ProInfo.Name;
fieldPropertyList.Add(mfi.ProInfo);
}
foreach (SchemaItem mfi in entityInfo.GetNeedUpdateFieldInfos())
{
if (sets != "") sets += ",";
sets += GetQuotedName(mfi.MappingFieldAttribute.FieldName) + "=@" + mfi.ProInfo.Name;
fieldPropertyList.Add(mfi.ProInfo);
}
return string.Format("{0} WHERE {1}", sets, query);
}
