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

IN 操作符允许我们在 WHERE 子句中规定多个值。
本篇文章中，还是使用和上篇文章中同样的实体类和数据库，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); }); }#endregionConsole.ReadKey(); }}}

程序运行结果：
【轻量级ORM框架Dapper应用之实现In操作】