轻量级ORM框架Dapper应用之实现In操作_实用技巧_

using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Configuration; using Dapper; using System.Data.SqlClient; using System.Data; using DapperApplicationByIn.Model; namespace DapperApplicationByIn { class Program { static void Main(string[] args) { // 定义连接字符串 string conn = ConfigurationManager.ConnectionStrings["AppConnection"].ConnectionString; #region in查询 using (IDbConnection connection = new SqlConnection(conn)) { var sql = "select * from Users where Email in @emails"; var result = connection.Query(sql, new { emails = new string[2] { "fqy@qq.com", "hyj@163.com" } }); result.AsList().ForEach(p => { Console.WriteLine("Id:"+p.UserId+" UserName:"+p.UserName+" Email:"+p.Email+" Address:"+p.Address); }); } #endregion Console.ReadKey(); } } }