I have a table containing several references to the same posts, themselves containing several references to the same languages like so : postId language name value 1 en title Post 1 title 1 en body This is the content for…
I have collection of Images in my Product class: public ICollection<Image> Images { get; set; } = null!; I ran into problem where Images are not being included when I try to take only 4 first products. This code includes…
Essentially I am trying to produce the following SQL query via Linq: SELECT * FROM `CustomerMainTable` AS `t` WHERE `t`.`CustomerMainTableId` IN ( SELECT MAX(`t0`.`CustomerMainTableId`) FROM `CustomerMainTable` AS `t0` GROUP BY `t0`.`CustomerMainTableCustomerId` ) CustomerMainTableId is an autoincrement id, and CustomerMainTableCustomerId is…
How do I write a LINQ query that would translate to the following SQL? SELECT u.id, u.username, a.id, MIN(a.created_at) AS firstArticle FROM users u INNER JOIN editorial_articles a ON a.user_id = u.id GROUP BY u.id ORDER BY u.id, a.created_at, a.id…
I have a problem. I want to join 3 tables in my asp.net web app but I am unsure on how to do that. Could you please help me? I want to join StudioId to a Movie table. However, Movie…
Here is my query. var Result = ( from t1 in dbContext.Table1 join t2 in dbContext.Table2 on t1.Id equals t2.Id join t3 in dbContext.Table3 on t1.Id equals t3.Id where && t1.CategoryUId == Input.CategoryUId select new CategoryInfo { Table1ID = t1.Id,…
I have applied GroupBy on columns of JArray and looping through all grouped list and from each group trying to get rows where "sectionGroup" column value is null. But when I try with Linq, it's returning Boolean list. I have…
I want to know what the exact difference is between the two methods - and when we need either of the two? I want to improve my querying skills.
Let consider this JSON { "data": "014", "theme": "COLORADO CASUAL", "family": "2163", "category": "00", "compo_groups": [ { "title": "HEAD024", "values": [ { "perc": "100", "desc": "COMP036" } ] }, { "title": "HEAD035", "values": [ { "perc": "100", "desc": "COMP042" },…
I get below data from Postgresql table, need to sum the ListDate field for each month and transpose. I tried this link Transpose a datatable using linq query , but not feasible or right approach to achieve it. ListDate MM…