linq 两个表的关联 不等于

[andy0618]

表A
CODE NAME
ZHANGSAN 张三
LISI 李四
WANGWU 王五

表B

ID ACODE VALUE
1 ZHANGSAN 10
2 WANGWU 9


我想取出A表里不在B表里的，所有记录
sql:select A.* FROM A,B where A.CODE!=B.ACODE

LINQ怎么写

[andy0618]

如果CODE是INT类型的流水ID怎么写呢 INT型的没有Contains方法

[EnForGrass]

var query=db.A.Where(t=>!db.B.Select(x=>x.CODE.ToString()).Contains(t.CODE.ToString()));

[EnForGrass]

var b= (from b in db.B select b.CODE); var a = db.A.Where(a=> !a.CODE.Contains(b)).ToList();

[threenewbee]

a.Select(x => X.CODE).Except(b.Select(x => x.ACODE)).Select(x => a.Single(y => y.CODE == x))

[EnForGrass]

引用 1 楼 Chinajiyong 的回复:

var b= (from b in db.B select b.CODE); var a = db.A.Where(a=> !a.CODE.Contains(b)).ToList();

var query=db.A.Where(t=>!db.B.Select(x=>x.CODE).Contains(t.CODE));

[ws_hgo]

    class A
    {
        public string name { get; set; }
        public string code { get; set; }
        public static List<A> GenerateData()
        {
            return new List<A>()
            {
                 new A (){name ="ZHANGSAN",code ="张三"},
                 new A (){name ="LISI",code ="李四"},
                 new A (){name ="WANGWU",code ="王五"}
            };
        }
    }
    /*
     ID     ACODE       VALUE
 1     ZHANGSAN    10
 2     WANGWU      9
     */
    class B
    {
        public string acode { get; set; }
        public string value { get; set; }
        public static List<B> GenerateData()
        {
            return new List<B>()
            {
                 new B (){acode ="ZHANGSAN",value ="10"},
                 new B (){acode ="WANGWU",value ="9"}
            };
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            List<A> aList = A.GenerateData();
            List<B> bList = B.GenerateData();

            var exceptE = aList.Where(a => !bList.Select(b => b.acode).Contains(a.name));

            exceptE.ToList().ForEach(a => Console.WriteLine(a.name));       
        }
    }

[piaofengshunli]

from query in DB.A where !DB.B.Any(x=>x.CODE==x.CODE) select query

[夜色镇歌]

引用 5 楼 Chinajiyong 的回复:

var query=db.A.Where(t=>!db.B.Select(x=>x.CODE.ToString()).Contains(t.CODE.ToString()));

~~

[嘟嘟虫]

[u011111276]

请问一下整么打开下载之后的资源？谢谢