Comparing two table IDs. ASP.NET MVC

I am currently loading two Orders and Colors tables, I wanted the Colors table to list the items that have the ID equal to Orders. For this, what occurred to me was to assign the IdOrders values to a variable and compare it with my IdOrders (in my table Colors), but it is not possible to assign the database's balance to my variable

My tables:

public partial class Orders {
public int ID_Orders {
get;
set;
}
public Nullable < System.DateTime > Data_Registo {
get;
set;
}
public string Num_Encomenda {
get;
set;
}
public string Ref_Cliente {
get;
set;
}
}
public partial class Colors {
public int ID_Orders {
get;
set;
}
public int ID_Programa_Malha {
get;
set;
}
public int ID_Linha_Cor {
get;
set;
}
public string Cor {
get;
set;
}
}

I am working with a database already in operation and possible these tables are already used in a sql join but not how to process that information.

As I said the first thing I remembered was to do this:

My Controller:

var id = from d in db.Orders select d.ID_Orders;
var color = db.Colors.Where(x =>x.ID_Orders = id).ToList();
var tables = new EncomendaViewModel {
Orders = db.Orders.ToList(),
Colors = color.ToList(),
};
return View(tables);

Error in id: CS0029 C# Cannot implicitly convert type to 'int' Erro id

Is it possible to process the data in this way?

Thanks for anyone who can help!

------------(Update)---------------

Using == cs0019 operator '==' cannot be applied to operands of type error2

My view in Broswer view

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

tavos tavos5y ago
i try this but list all colors

var color = db.Colors.Where(x => id.Contains(x.ID_Orders)).ToList();
Sachin Singh5y ago
you have a collection (IQueryable) of Id as below
var id = from d in db.Program_Cor
select d.ID_Program;
Now you are comparing it with single Id   int , it is not possible , how can you compare 2 with 2=2,3,4,5,6
no you can , if you want to compare with collection then you can use Contains method.
var cor=db.Program_Cor.Where(x => id.Contains(x.ID_Programa)).ToList();