C# (2015 .NetFramework4.6)のEntity FrameworkのJoinして入手したデータのカラム数が多いのでテーブル名で指定したい Entity Frameworkjoin moneyCashJoin Cash var addData = context.Maney.Where(n=>n.DATE==date && n.CODE==Code) .Join(context.Cash, man => man.ID, cash => cash.ID, (man, cash) => new { cash.colA,cash.ColB});// var addData = context.Maney.Where(n=>n.DATE==date && n.CODE==Code) .Join(context.Cash, man => man.ID, cash => cash.ID, (man, cash) => new { cash.*}); // var addData = context.Maney.Where(n=>n.DATE==date && n.CODE==Code) .Join(context.Cash, man => man.ID, cash => cash.ID, (man, cash) => new Cash()); //" 'DATABase.Cash' LINQ to Entities "

var addData = context.Maney
.Where(n=>n.DATE==date && n.CODE==Code)
.Join(context.Cash,
man => man.ID,
cash => cash.ID,
(man, cash) => cash);





var addData = context.Cash
.Where(cash => context.Maney.Any(man => man.ID==cash.ID && man.DATE==date && man.CODE==Code));