Category "linq"

Add one object in list nested entity in EF Core

I create a repository layer in my app. I don't need all list EntityList. I want add in Foo.EntityList 1 object which equals entityId, and return foo in notImpor

C# find JSON value based only on Key name through multiple levels of array

I have a variety of input JSON formatted data which all contain a particular key-name terminalSize. This is the only piece I know. The total number of JSON tree

In Entity Framework Core 3.1, what is the best way to dynamically provide table name to a query?

I have seen options for .NET 5, .NET Core 2.0, etc. but none of them seem to work for .NET Core 3.1 What is the best way to provide table name, in a variable, t

Using linq to return records from sql server based on users datetimeoffset

I have a dateTime offset value that gets passed from the UI which looks like startDate:2022-04-25 21:08:02.2973333 +00:00 but the date i entered is actually the

Using SelectMany on IQueryable vs IEnumerable

I wanted to do a little experiment to see the cost of operations if I process the data at CosmosDB and return it, vs. if I read the whole document and process i

LINQ to SQL, 'Linq' does not exist in the namespace 'System.Data'

I tried to connect my project to a database, using LINQ to SQL, following a few online guides. I created a simple database Library, added new LINQ to SQL Classe

LINQ select column that contains some array element

I have a field "details" varchar(MAX) in my table with the detailed description of an item, I need to select the records that contain the keywords passed by the

Is Using EF Core Value Converter Preventing the Contains() LINQ Method from being Translated to SQL?

I have a Movie class. It has a Genres property of type List<string>. I use this exact EF Core Value Conversion to store it in the database as a comma-sepa

If it possible accelerate From-Where-Select method?

I have two var of code: first: struct pair_fiodat {string fio; string dat;} List<pair_fiodat> list_fiodat = new List<pair_fiodat>(); // list filled

Using Asp.Net Core Viewbag

Layout.cshtml @{ var menus = (IEnumerable<WebApplication.Models.TopMenu>)ViewBag.menus; } <div class="col-md-8"> <!-- Menu Partia

C# LINQ Filter records in child tables

I have a main table "SALES" and two secondary tables "PRODUCTS" and "SERVICES", I need to select only the records in "SALES" that contain some product or servic

Using C# LINQ with MongoDB Find

I am only about 3 days into using MongoDb and C# driver so be gentle. ;-) I have a MongoDB query working with AsQueryable. I would like to use the collection.Fi

Looping through multiple collection of arrays

I have a lot of data as response not parsed and also, so you can see what is in the response. But I want all the scores from the table results, the query filter

How to merge two lists using LINQ Suming especifics fields with sublists

Considering I have 2 list (listaProduto1 and listaProduto2), both with same properties, but with different values. I need the result merge both lists, but it mu

Differences between IQueryable, List, IEnumerator?

I am wondering what the difference between IQueryable, List, IEnumerator is and when I should use each one? For instance when using Linq to SQL I would do some

Groupby and Compare the results in Linq

I have the following recordset for a given School (i.e., ABC in this example) , I need to groupby on Class and Activity and take the first row . Then I need to

.net core linq select overload index does not work

I got a linq lambda select code that works before I added the Select index overload. Before, I got the list of records but I need the index which I use to assig

Implement an SQL query in LINQ

I'm trying implement the follow query in LINQ, but I don't find solution: SQL: SELECT COUNT(*) AS AmountMonths FROM (SELECT SUBSTRING(CONVERT(NVARCHAR(12), pay_

How to select multiple elements into array in Linq query?

Net core application. I have below query in my application var result = sourceProposal.Quotes .Where(x=>x.QuotationId == sourceQuoteId) .FirstO

How to merge two lists using LINQ Suming a especific field when the id matched

Considering I have 2 list (firstList and secondList), both with same properties, but with diffent values. I need the result merge both lists, but it must consi

Other Categories