利用反射动态构成sql语句

关注

原创最新推荐文章于 2026-04-13 10:51:29 发布 1.2k 阅读 AI 写同款· GEO 优化 ›

C#反射获取实体类对象属性拼接生成增删改SQL语句完整实例源码 1.创建一个SQL生成帮助类分别写出以下增删改三个公共方法数据插入方法 public static int Save(object obj) { int n = 0; using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); StringBuilder 阅读详情

class Program
    {
        static void Main(string[] args)
        {
            People p = new People();
            Insert(p);
        }

        public static bool Insert(object obj)
        {
            Type type = obj.GetType();
            string tableName = "tb_" + type.Name;
            string sql = "insert into " + tableName + "(";
            PropertyInfo[] properties = type.GetProperties();
            foreach (PropertyInfo pInfo in properties)
            {
                sql += pInfo.Name + ",";
            }
            sql = sql.Substring(0, sql.LastIndexOf(','));
            sql += ") values(";
            foreach (PropertyInfo pInfo in properties)
            {
                sql += "'" + pInfo.GetValue(obj, null) + "',";
            }
            sql = sql.Substring(0, sql.LastIndexOf(','));
            sql += ")";

            return true;
        }
    }
    class People
    {
        public string Name { set; get; }
        public string Age { set; get; }
        public string Sex { set; get; }
    }