Recent questions tagged linq

0 votes

492 views

1 answer

linq string.contains on field of child object list

How can the linq statement here be altered so that it finds the company(s) containing the user with the substring of ... third")).ToList(); } } See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

linq to sql checking for null

my database field int_ParentId consist of a Null value . how would i check it for a null in this linq query . it ... m => m.int_ParentId==null); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

linq to sql - Why do I get "error: ... must be a reference type" in my C# generic method?

In various database tables I have both a property and a value column. I'm using Linq to SQL to access the ... blind and use a screen reader). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

552 views

1 answer

linq - Executing a certain action for all elements in an Enumerable<T>

I have an Enumerable<T> and am looking for a method that allows me to execute an action for each element, ... but it wasn't printing anything. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

703 views

1 answer

linq to sql - C#, Linq2Sql: Is it possible to concatenate two queryables into one?

I have one queryable where I have used various Where and WhereBetween statements to narrow the collection down to a ... me some pointers here? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

528 views

1 answer

linq - Error 6046: Unable to generate function import return type of the store function

I have a scalar-valued function in my sql database. I receive this error when importing this function into Entity ... ,2))) return @Result END See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

708 views

1 answer

linq to sql - TransactionScope Error against Sql Server 2000 - The partner transaction manager has disabled its support for remote/network transactions

I am trying to set up a simple transaction for my Linq-to-Sql actions against my Sql 2000 database. Using ... server and on my client machine. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

402 views

1 answer

linq to sql - Best-practices for localizing a SQL Server (2005/2008) database

Question I'm sure many of you have been faced by the challenge of localizing a database backend to an ... , would be very apprechiated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

linq - How should I get started learning about ADO.NET Entity Framework?

So here I am just about to start a big project using LINQ to SQL and then I read this: Is LINQ to ... learning about ADO.NET Entity Framework? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

837 views

1 answer

linq - Querying complex nested object in cosmosdb using sql Api

How query only those users whose Itemcount > 10 from the complex nested object(with dynamic key) from comosdb using sql api? ... "6454" } } } } See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

536 views

1 answer

linq - Passing multiple parameters to web API GET method

I have created a WEB API using MySQL Database. The API works as expected for now. I sent a meter serial ... help would be highly appreciated. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

577 views

1 answer

linq - When quering over a base type why does the EF provider generate all those UNION All clauses

If I have a model that looks like this: and I do a Linq to Entities query like this: var c = ... the unnecessary complexity of this query. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

654 views

1 answer

linq - C# interweave two uneven List into a new List

I have two List, both of different lengths. What I am trying to achieve is a third List that contains the first element ... ", "4070", "4072" }; See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

linq - Combining 2 lists and and remove duplicates .Output in a third list .My attempts do not work

I always seem to have a problem when I need to compare 2 list and produce a 3rd list which include all unique items ... Category { get; set; } } See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

574 views

1 answer

linq - What is the best way to mix VB.NET's Option Strict and the new Option Infer directives?

In a related question, my team is about to (hopefully) start using LINQ, and I'd like to take advantage ... and the new Option Infer directives? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

465 views

1 answer

linq to sql - F# SQL type provider - why aren't all stored procedures provided?

I'm trying to access an existing database via the Microsoft.FSharp.Data.TypeProviders.SqlDataConnection type. There are ... from a temp table. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

704 views

1 answer

linq - DataTable select method with single quote conflict C#

I recently found when I do a LINQ select under a field that contains an apostrophe, it makes my application to ... it or remove it, please? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

646 views

1 answer

linq - Unable to create a constant value of type (type) Only primitive types ('such as Int32, String, and Guid') are supported in this context

I've read ALL of: Unable to create a constant value of type 'System.Object' in Entity Framework Entity Framework - ... I get my query to work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

564 views

1 answer

linq - left outer join problem

I need to convert some SQL statement to LINQ. How convert LEFT OUTER JOIN to equivalent LINQ statement? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

769 views

1 answer

linq - Can't perform Create, Update or Delete operations on Table because it has no primary key

I've been trying to insert row in the table having an identity column RequestID (which is primary key as well) ... the trick, does anybody know? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

566 views

1 answer

linq - Do you ToList()?

Do you have a default type that you prefer to use in your dealings with the results of LINQ queries? By default ... codebase. What do you do? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

976 views

1 answer

linq - Get All Children to One List - Recursive C#

C# | .NET 4.5 | Entity Framework 5 I have a class in Entity Framework that looks like this: public class ... Thanks for all of the help! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

788 views

1 answer

linq - Pass a lambda expression in place of IComparer or IEqualityComparer or any single-method interface?

I happened to have seen some code where this guy passed a lambda expression to a ArrayList.Sort(IComparer here) ... you. Nice, though. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

566 views

1 answer

linq - OData "where ID in list" query

I have an OData service where I'm trying to filter by a list of IDs; the SQL equivalent would be something ... "or media_id eq 100" clauses? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

676 views

1 answer

linq - Entity Framework T-Sql "having" Equivalent

How can I write a linq to entities query that includes a having clause? For example: SELECT State.Name, Count(*) ... StateID HAVING Count(*) > 1 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

497 views

1 answer

linq - ExpressionVisitor soft delete

We're having some issues implementing soft delete functionality with entity framework. The idea is to use a ... Navigation property /// </summary> public class InjectConditio...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

642 views

1 answer

linq - Pagination in C# against DocumentDB without Skip

I was wondering if there is any way to implement pagination in C# against DocumentDB with, or without, their ... and pageSize in the request? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

949 views

1 answer

linq to entity framework: use dictionary in query

I have: Dictionary<int, List<int>> dict = new ... var a = SomeEntity.Where(f => dict[f.key].Contains(f ... linq to EF or am I missing something? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags