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 ajoin bb in b on aa.BUILDID equals bb.BUILDIDselect new{ aa.ROOMID,bb.BUILDNAME, };foreach (var item in query){Console.WriteLine(item.BUILDNAME+"--"+ item.ROOMID);}