LINQ Query

492

Solutions

367

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

Hello, I have an XML with repeating nodes that I am trying to read with Linq.  Here is sample XML

(CODE)
Here is my Linq code so far.
(CODE)

Thanks for any help

324 views
Free Tool: Port Scanner
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Hi Experts.

I have a grid that displays a comma separated list of a users roles using  the following LINQ :

Roles.Text = string.Join(", ", rolesList.OrderBy(x => x.Name ).Select(x => x.Name)); …

1132 views

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 …

543 views

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 …

443 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 …

354 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)

3137 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 …

150 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

851 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 …

350 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 …

1333 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.

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,…

1672 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 …

4128 views

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 …

8141 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 …

449 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
          …

480 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? …

1054 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              …

691 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
                               …

1276 views

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

178 views
Free Tool: Path Explorer
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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:

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

3105 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. …

761 views

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…

3169 views

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

151 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 …

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

LINQ Query

492

Solutions

367

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
>