Dapper 批量操作sql

最新推荐文章于 2023-06-09 16:10:24 发布

weixin_30951231

最新推荐文章于 2023-06-09 16:10:24 发布

阅读量928

点赞数

文章标签： c# 数据库

原文链接：http://www.cnblogs.com/25miao/p/7055552.html

版权

    static void Main(string[] args)
        {
　　　　　　　　private static readonly string sqlconnection ="";
            //遍历循环client表
            IList<Clients> StuList;
            using (var connection = new System.Data.SqlClient.SqlConnection(sqlconnection))
            {
                connection.Open();
                 StuList = connection.Query<Clients>("select Prefix from Clients").ToList();
                connection.Close();
                
            }
            var conn = new System.Data.SqlClient.SqlConnection(sqlconnection);
            conn.Open();
            try
            {
                int i = 1;
                foreach (Clients item in StuList)
                {
                    var file = Environment.CurrentDirectory + "\\sql.txt";
                    var sql = System.IO.File.ReadAllText(file);
                    sql = sql.Replace("{t}", item.Prefix);
                    int result = conn.Execute(sql);
                    Console.WriteLine("建立表--"+i+"----"+ item.Prefix+"_QueryLog");
                    i = i + 1;
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            conn.Close();
            Console.ReadLine();
        }