public static string GetFindEntitySql(string propertyValue)
{
Type type = typeof(class1); //class1为类
string tableName = type.Name;
string sql = "SELECT top 1 ";
PropertyInfo[] properties = type.GetProperties();
foreach (PropertyInfo pInfo in properties)
{
sql += pInfo.Name + ",";//循环每一个属性 对应数据表中的字段
}
sql = sql.Substring(0, sql.LastIndexOf(','));
sql += " FROM " + tableName;
sql += " WHERE " + properties[0].Name + "=" + propertyValue;
return sql;
}
利用反射将实体类中的属性拼凑为一个待执行的sql
最新推荐文章于 2022-06-06 13:26:14 发布