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); }