Questions tagged [linq]

The tag has no usage guidance.

5 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
0
votes
2answers
53 views

How to group by linq based on input parameter?

I want to use group by in C#, and my result must be like this code in SQL: SELECT MAX(EffectiveDate) AS EffectiveDate,details.PersonnelBaseID FROM dbo.tkp_PersonnelDetails AS details where details....
0
votes
0answers
38 views

How to join multiple tables

I'm Stuck at Joining multiple tables. Context: i have order table which is linked to productTable(name: ORDER_DETAILS) and recipeTable(ORDER_RECIPEs).I can order product from product menu and ...
0
votes
1answer
246 views

Advice needed regarding design of database schema keeping record of current stock

Disclaimer: I am a beginner in the field of database. I am trying to design a database in PostgreSQL which will record the sales and purchases of items. I intend to use this database as the model ...
0
votes
1answer
57 views

Check for existing matches to find the field their grouped-by

So I have a table of values associated with different sessions using a field called sessionid, lets say the table has 3 other fields: itemcode, itemcost, & itemeffect. What I end up doing, is ...
-1
votes
1answer
363 views

Splitting rows into columns with group by clause

I have three tables Lab, Payments and Transaction I want to spilt transType into two columns, sum TransType Group By BillId and compare it with Lab.TotalBill to get Refundable Payments/Due payments I ...