LINQ Query

483

Solutions

344

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

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 …

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

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)

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

117 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

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

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

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

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

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

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

428 views
Networking for the Cloud Era
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

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
          …

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

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

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

1264 views

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

157 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:

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

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

746 views

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

(CODE)

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

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

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

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

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

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

1661 views

Hi

I had question on this Refactor C# code (https://www.experts-exchange.com/questions/28958730/Refactor-C-code.html).

How do I query this if we have more than Single record for …

1099 views

I have the following method and its a linq statement.


I would like this method to update the database.

If there is any failure I want it to return false..

else true..

So I can use that …

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

LINQ Query

483

Solutions

344

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
>