Dapper链接查询学习

先创建一个SQLservert连接

 IDbConnection dapper = new SqlConnection("Data Source=.;Initial Catalog=xx;User ID=xxx;Pwd =xxx;");

定义两个model 比如 ROOM<住户>   BUILDING<楼房>,然后查询

var a = dapperStation.Query<ROOM>("select * from ROOM");
var b= dapperStation.Query<BUILDING>("select * from BUILDING");

按照业务需求提取数据

    var query = from aa in a
                        join bb in b on aa.BUILDID equals bb.BUILDID
                        select new
                        { 
                            aa.ROOMID,
                            bb.BUILDNAME, 
                        };

            foreach (var item in query)
            {

                Console.WriteLine(item.BUILDNAME+"--"+ item.ROOMID);

            }