linq Questions

Phpmyadmin – C# EF Core MySQL to LINQ return nothing

February 15, 2024
Vincent Krisna
2 Answers

var IdSubProduct = new MySqlConnector.MySqlParameter("IdSubProduct", this.parameter.Id.ToString()); FormattableString cmd = $@"SELECT spr.*, c.Name CustomerName FROM ProductSubProductRate spr LEFT JOIN LibraryCustomer c ON (c.Id = spr.CustomerId) WHERE (spr.IdSubProduct = {IdSubProduct})"; this.contextSQL.ProductSubProductRate.FromSql(cmd).ToList(); this.contextSQL.ProductSubProductRate .Include("Customers") .Where(pr => pr.IdSubProduct == this.parameter.Id.ToString()) .Select(pr => new {…

VIEW QUESTION

Asp.net – How to filter and group records efficiently in C#

January 15, 2024
asm
2 Answers

A table Work has three columns: ID, Region and Worker. And there are two DropDown lists. DropDown A: Select and filter the Region, is bound to region with data regions DropDown B: Select and filter the Worker, is bound to…

VIEW QUESTION

Postgresql – LINQ equivalent of keyset based pagination in postgres

January 5, 2024
Amit Kumar
2 Answers

I have a postgresql query that does pagination using a keyset-based approach. SELECT * FROM public.values_with_variable_view WHERE ( timestamp, id) > ('2024-01-04 01:12:09.267335+00',1996) ORDER BY ( timestamp, id) asc LIMIT 100 I have a requirement to write this using LINQ…

VIEW QUESTION

Mysql – dbContext.SaveChanges() not updating single row as expected in .NET

November 28, 2023
Krushnal Patel
2 Answers

I have 2 tables: TableA and TableB in MySQL on which I am trying to do some CRUD operations in .NET. I have written a function to insert a new row in TableA followed by updating a single row in…

VIEW QUESTION

Asp.net – How Can I dynamically create an "OR" LINQ query based on input parameter conditions

My problem is a bit more complicated, so I have simplified it with the below example. Let's say I have a simple list of Integers. I receive two condition input parameters in my function which tell me how to…

VIEW QUESTION

How to Loop through IEnumerable List and if there are any duplicates, sum a value each duplicate has and remove the duplicates in ASP.Net MVC C#

November 1, 2023
Kip M.
2 Answers

I have an inventory usage page that is populated with a list of items I've used over the course of a certain period of time (like a month or so). There's a good amount of items that are duplicates and…

VIEW QUESTION

Asp.net – Improving the speed of a query?

September 25, 2023
AkshatSparrow
2 Answers

I am trying to improve the performance of a query. I was thinking of using AsNoTracking(), but I am not sure if the location where it is put will make a difference i.e.(before Select() or after, before Include() or after,…

VIEW QUESTION

Asp.net – How to use ternary operator linq where clause

August 16, 2023
Pinky
2 Answers

Table : Id, Name,Subject,Score 1 Pinky English 60 2 Pinky Maths 40 3 Mahesh Maths 50 4 Rani Maths 50 5 Rani Eco 50 I want to fetch record from table ,when Subject is maths, need record whose score should…

VIEW QUESTION

Mysql – LINQ Query for below table

August 16, 2023
Rani Thakur
2 Answers

Table data: Id_Org_hierarchy Hierarchy_Name Parent_Id_Org_hierarchy 1 OGt 0 2 NHT 1 3 BATCH 1 2 3 Voice 1 I need result Like Below: Batch1(NHT,OGT) Details : Id_Org_hierarchy column value is present in Parent_Id_Org_hierarchy and so on its a tree struct…

VIEW QUESTION

Postgresql – How to parse text json in linq with Entity Framework

August 2, 2023
VovaLeder
2 Answers

I have a table SliceStatements (DB: PostgreSQL) that has a column Payload. The column's datatype is String but the string is in json format. The json has field rows which is an array of objects. It is known that each…

VIEW QUESTION