I have a LINQ query (with EF)
I have the following LINQ query please Guidance how can I use a case or case statement in this case.
var Selected result = Add invoice by invoice Invoice Join BookedAreasSet BookedAreas in the area on BookedAreasSet on BookedAreasSet.InvoiceID AreaSet equal to InvoiceSet.InvoiceID. The area is equal to field area. Select the new invoices. Invoice number, invoiceet.mount, invoice date discount, invoiceet GST, invoice Paymentset, Invoice Set. Shopping Centre, Bucharest, Arcadia Buked Ariad, Ariasetknam // Here I Case / wants to use that have a statement based on another column}; Please > But you can do it this way ternary operator ? var can use selected results are equal InvoiceSet.InvoiceID in BookedAreasSet BookedAreas connected InvoiceSet the Invoices equivalent region in Join BookedAreasSet.AreaID in BookedAreasSet.InvoiceID region is. Select Aeroids new {InvoiceSet.InvoiceNumber, InvoiceSet.Amount, InvoiceSet total discount, InvoiceSet.GST, InvoiceSet.PaymentDate, InvoiceSet.ShoppingCentreID, BookedAreasSet.BookedAreaID, AreaSet.Name, YourColumn = AreaSet.YourColumnName == Your variable? "First results": "Other results?"} You can combine several situations like this.
Kshetrasetkapaka Colmnam == your variables? "First Result": AreaSet. Your Column Name == Your Secured? "Some Results": "Some Other Results"
Comments
Post a Comment