Join table and show in view using linq

Question

This is my code

public List<InvoiceJoin> ShowIvoiceList()
{
   InvoiceJoin ij = new InvoiceJoin();
   List<InvoiceJoin> list; 
   var data = (from t in _Entity.TblInvoices join t0 in _Entity.TblClients on new { ReceiverCode = t.ReceiverCode } equals new { ReceiverCode = t0.ClientCode }
   select new
   {
      t.RakeNumber,
      t.ReceiverCode,
      t.ConsigneeCode,
      t.InvoiceNumber,
      t.InvoiceDate,
      t.RecordStatus,
      t0.ClientCode,
      t0.ClientDescription,
      t0.ClientAddress1,
      t0.ClientAddress2,
      t0.ClientAddress3,
      t0.ClientCity,
      t0.ClientState,
      t0.ClientCountry,
      t0.ClientZipCode,
    }).ToList();

    foreach (var item in data)
    {
       list.Add(item);
    }
    return list;
}

my invoicejoin class

public class InvoiceJoin
{
    public TblInvoice invoice { get; set; }
    public string Cdetails { get; set; }
    public string Cname { get; set; }
    public string Caddr { get; set; }
    public string Pname { get; set; }
    public string Paddr { get; set; }
}

Its not working I need to show two sql table data list in single view how i can do this in linq pls some ne help friends i need to show in html table. . .

You can pass the returned list to the view. From view's perspective, the data is just a collection of items. — Bishnu Paudel
– Bishnu Paudel, Commented Jan 16, 2014 at 5:31

potehin143 · Accepted Answer · 2014-01-16 05:45:00Z

1

make sure that you have class InvoiceJoin with constructor which take 2 parameters: invoice and client

class InvoiceJoin
{
   private TblInvoice invoice;
   private TblClient client;
   public InvoiceJoin(TblInvoice invoice,TblClient client)
   {
      this.invoice=invoice;
      this.client=client;
     //...
   }
    public string RakeNumber{ get{return invoice.RakeNumber} set{invoice.RakeNumber=value;}}
   //... ather invoice properties you want to see in grid
    public string ClientCode{ get{return client.ClientCode} set{client.ClientCode=value;}}
   // ...ather clientproperties you want to see in grid
}

loading data:

List<InvoiceJoin> data = (from invoice in db.TblInvoices
                          join client in db.TblClients
                          on  invoice.ReceiverCode equals client.client 
                          select new{Invoice=invoice,Client=client}).ToList() 
                          .Select(n=>new InvoiceJoin(n.Invoice,n.Client)).ToList()

answered Jan 16, 2014 at 5:45

potehin143

5314 silver badges9 bronze badges

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

6 Comments

Dinesh Over a year ago

ok but its not working which column i needed then that only i need to set property in invoicejoin class may i right

Dinesh Over a year ago

Ya friend its working But how can i will pass in view for example (foreach(var item in model){}) like this its not coming

Dinesh Over a year ago

How i can add 3 tables like this

potehin143 Over a year ago

The question was how to show this two tables. And it is a simple solution according with the task. But if the target goal is to show so much tables as you want, it the reason to think about implementation of dynamic dictionary for the join class. In that case it,s constructor will get objects collection and make all needed properties.

potehin143 Over a year ago

If you need just show values you may return from query anonymous type with a tuple of needed values and bind this collection directly to grid without joinclass cover

|

Cam Bruce · Accepted Answer · 2014-01-16 05:32:47Z

1

Use the LINQ Union method like this:

var data = (from t in _Entity.TblInvoices
              join t0 in _Entity.TblClients on new { ReceiverCode = t.ReceiverCode } equals new { ReceiverCode = t0.ClientCode }
              select new
              {
                  t.RakeNumber,
                  t.ReceiverCode,
                  t.ConsigneeCode,
                  t.InvoiceNumber,
                  t.InvoiceDate,
                  t.RecordStatus,
                  t0.ClientCode,
                  t0.ClientDescription,
                  t0.ClientAddress1,
                  t0.ClientAddress2,
                  t0.ClientAddress3,
                  t0.ClientCity,
                  t0.ClientState,
                  t0.ClientCountry,
                  t0.ClientZipCode,
              }).Union( // 2nd linq query with same result set as first here);

answered Jan 16, 2014 at 5:32

Cam Bruce

5,68924 silver badges37 bronze badges

2 Comments

Dinesh Over a year ago

i Cannot Understand friend if i use union what it happened and then how can pass this list to view or bind in model and i can do in invoicejoin class

Dinesh Over a year ago

how i can join more than two tables like this

Collectives™ on Stack Overflow

Join table and show in view using linq

2 Answers 2

6 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related