LINQ Query

487

Solutions

365

Contributors

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

Related Topics

  1. C#
  2. .NET Programming
  3. Visual Basic.NET
  4. ASP.NET
  5. Microsoft Development
  6. Microsoft SQL Server
  7. Query Syntax
  8. XML
  9. Programming Languages-Other
  10. Microsoft SQL Server 2008
Refine results

Is there a solution using LINQ to build a new string based on the following criteria?

Concatenate each uppercase letter to the left of each # , then include everything after the last #. A few …

527 views
Announcing the Most Valuable Experts of 2016
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

So i'm trying to familiarize myself with the expression syntax of linq, you know the upside down SQL stuff; it's a bit of a change from the method based which i'm used to, but not too bad; however i …

426 views

I am trying to join 2 objects.  ProductData and ProductJoin.  My code sample is below.  I want to get all of ProductData and the Top 1 of ProductJoin sorted on date descending so I get the last entry …

337 views

Below is some sample code.  I am trying to figure out how to use LINQ and select data from a List<> and return it to an object.  Code I am trying to resolve is located below the ?????.
(CODE)

349 views

Hello all,

I have a table CustomerAccount that has a field called TransactionDate that is loaded to with the same transaction date about 3k records a day.   I need to get all the records from this …

132 views

Below is my linq / c# and it return duplicated record. All I need to return one "blue shied"
How can I do that?


(CODE)

Result:
Blue Shield
Blue Shield
Blue Shield
Blue Shield

837 views

I'm creating a DropDownListFor using this code:
(CODE)
This is the LookupGroup values (converted to JSON):
(CODE)
This is the ANSWER_LOOKUP_OPTION_ID value: 9

How can I clear the selected flag …

337 views

Hi Guys,

I have table in sql database with column that gives random number when you insert new row.
Now I built MVC application that going to insert new rows to this table and the only column …

1325 views

Hi,
I have a Linq query that runs a search in 2 tables (through a "Join"):

First table is tblProducts where master data for any product is saved (Name, Barcode, ItemCode, EnglishName, SpanishName,…

1657 views

i have a data from database which includes some columns. one of them is ExpiryDate. it has SAP datetime format : MM/dd/YYYY nn:mm:ss AM



i wanna convert it from MM/dd/YYYY hh:mm:ss AM to …

4107 views
On Demand Webinar - Networking for the Cloud Era
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

hi there ,
when the form is load i load all the data to the customer entity class
var cust = EF.GetCustmoer(long cid);
now i have all the data in the cust object
when the form closed i want to …

8121 views

I'm new to LINQ.  I've create some test code using simple LINQ syntax in VB.NET.   So, is this all there is to LINQ - A query-type syntax that is part of the VB.NET and C#.NET?   Do other languages …

437 views

What does AsEnumerable() do in the code below?   The code works with or without it.

Dim results = From car In cars.AsEnumerable()
                Select car.make, car.model, car.color
          …

464 views

I'm new to LINQ.   Below I created some simple code.   I want to now have the data source be XML.   Is there a way to use the exact same LINQ SELECT/QUERY code  (i.e., Dim results = ) again XML data? …

1047 views

Hello Experts,
i have the following C# data object:  image attached.



1. I want to write a C# LINQ query to group by Model ID and Sum of Stock QTY

Output Should be :

ModelID              …

681 views

i want to convert the below Queries from C# to VB.Net:

1.
              var results = from p in objStock
                              group p by p.Model into g
                               …

1268 views

I have a product class and it contains an array of categories.
How can I use linq to query by a provided category?

167 views

Hi
I am not an experience in LINQ so far, and is having the following error:

New transaction is not allowed because there are other threads running in the session

My code:

--------------

392 views

Dear Experts,
How do I can combine the results in this LINQ query?

c.field == 1 below generates results and c.field == 3 generates results but how can I show the list of both results together. …

754 views
Free Tool: SSL Checker
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I have this statement that returns ISBN and Price. How can I look up values on this result?

(CODE)

433 views

Hello,

I am having some difficulties with getting the correct statement in lambda or linq.  


SQL Query
select count(me.schools_id) as numOfStudent, schools_name, members_exams_examdate
from…

3149 views

I have a collection of Product IEnumerable<Product> products.
            How can i filter this collection with an IList<string> items using linq.

144 views

I am accessing a jSon response using LINQ query. Attached is the Json response, the class I have declared with the fields and my LINQ query.

I have to group the items if they have the same …

560 views

I am working on the attached jSon response. I need to read the sub-array named "details" and populate a datagrid.
I am using VB.NET.

Attached is how I declared the classes to be used in my LINQ …

2129 views

Hi,

I added a new employee to SQL table.
Add(3, "Issy", "Holm");
And I added this to the List.
(CODE)


Then, check this in the sql db.
I have a DataTable called dt. Now here is what I want …

1666 views
Show more content
201506-LO-Top-001

LINQ Query

487

Solutions

365

Contributors

Language Integrated Query (LINQ) is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, although ports exist for Java, PHP, JavaScript and ActionScript. LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

Related Topics

  1. C#
  2. .NET Programming
  3. Visual Basic.NET
  4. ASP.NET
  5. Microsoft Development
  6. Microsoft SQL Server
Top Experts In
LINQ Query
<
Monthly
>