You’ll have to perform two database queries: var IDs = (from a in db1.Table1 join b in db1.Table2 on a.Id equals b.Id orderby a.Status where b.Id == 1 && a.Status == “new” select new a.Id).ToArray(); var query = from c in db2.Company join a in IDs on c.Id equals a.Id select new { Id = … Read more
Your entity model has the combination of the two properties FTPRuns.ID and FTPRuns.LastRun as entity key while your table has only the column FTPRuns.ID as primary key. So in your model you specify that the combination of FTPRuns.ID and FTPRuns.LastRun must be unique while your database has the stronger requirement that FTPRuns.ID alone must be … Read more
Click in an open area of the designer: Go to the Properties tab: In the dropdown box at the top, select your table. You should then see it highlighted in the designer.