利用反射动态构成sql语句

最新推荐文章于 2022-04-26 16:36:30 发布

原创最新推荐文章于 2022-04-26 16:36:30 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

C# 专栏收录该内容

25 篇文章

订阅专栏

本文介绍了一个使用C#动态构建SQL插入语句的例子。该示例通过反射获取对象属性，并将其转换为SQL字段及值，实现了不同对象类型的通用插入操作。

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