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<User>(sql, new { emails = new string[] { "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();

         }

     }

 }