Comparing two table IDs. ASP.NET MVC

Question

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'

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

My view in Broswer

dbEntities sd = new dbEntities();
        List<Orders> orders= sd.Orders.ToList();
        List<Colors> colers= sd.Colors.ToList();

        var multipletable = from c in orders
                            join st in colers on c.ID_Programa equals st.ID_Programa into table1
                            from st in table1.DefaultIfEmpty()                                
                            select new MultipleClass { orders= c, colers= st  };

Does the error occur in this line ? db.Colors.Where(x => x.ID_Orders = id).ToList(); You need to use "==" incase you are comparing two things -> db.Colors.Where(x => x.ID_Orders == id).ToList(); — Vidiya Prasanth Pappannan
– Vidiya Prasanth Pappannan, Commented Dec 11, 2020 at 9:22
I'm using only = because if I use == it gives me an error : cs0019 operator '==' cannot be applied to operands of type — Miguel
– Miguel, Commented Dec 11, 2020 at 9:30
from d in db.Orders select d.ID_Orders returns the collection instead of single element. If you require an element then select the first (or what ever require) and do the comparison using == — user1672994
– user1672994, Commented Dec 11, 2020 at 9:30
using join I can only list the colors ordered, do not list them within the orders because I have more colors, I leave a new scheme above for those who can help. — Miguel
– Miguel, Commented Dec 15, 2020 at 10:27

Vidiya Prasanth Pappannan · Accepted Answer · 2020-12-11 09:35:34Z

2

There could be one or more values returned from the below query.

var id = from d in db.Orders
         select d.ID_Orders;

That is the reason why it was throwing an error. So lets try it this way

var color = db.Colors.Where(x => id.Contains(x.ID_Orders)).ToList();

answered Dec 11, 2020 at 9:35

Vidiya Prasanth Pappannan

7236 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Miguel Over a year ago

so it works but list all ids, do not list ids equal to Order

Vidiya Prasanth Pappannan Over a year ago

In that case , you need to fix your var id = from d in db.Orders select d.ID_Orders; to return only the ID you need.

Miguel Over a year ago

how can i return the id value of each listing? on top I put a picture of what is being presented to me

Miguel · Accepted Answer · 2020-12-16 16:04:43Z

0

 public class OrderWithColorsViewModel
{
    public Order order { get; set; }
    public List<Colors> colers{ get; set; }
}

Public class TestOrderController : Controller
{
    public DailyMVCDemoContext db = new DailyMVCDemoContext();
    public ActionResult Index()
    {
        var orders= db.Orders.ToList();
        var colers = db.Colors.ToList();
        var result = (from c in orders
                     join st in colers on c.ID_Orders equals st.id into table1
                     select new OrderWithColorsViewModel { order =c, colers = 
                     table1.ToList() }).ToList();
        return View(result);
    }
 }

credits: YihuiSun

answered Dec 16, 2020 at 16:04

Miguel

1399 bronze badges

Collectives™ on Stack Overflow

Comparing two table IDs. ASP.NET MVC

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related