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);

            }