LINQ Query

477

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.

Refine results

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 …

1310 views
Netscaler Common Configuration How To guides
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

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

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

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

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

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

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

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

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

1258 views

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

153 views
Does Powershell have you tied up in knots?
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

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:

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

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

742 views

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

(CODE)

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

3105 views

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

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

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

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

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

1082 views
Simplifying Server Workload Migrations
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

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 …

664 views

I would like to get the percentage of a "type" of questions within an exam.  I am able to get the total number each  "type" of question and I am able to get the total number of questions in an exam. I…

963 views

I have a .net winform with a text box for file types.

A user would key in the text box a list of file types separated by a comma.

I would store that string in a variable like so below.

Then I…

355 views

I have a data object that I pass to my gridview user control as a generic list and I would like to just use the fields/properties that I am returning from the stored proc I am running. My object has …

583 views

Figured out how to update most of the XML elements.  I'm having issues with two.  I want to updated the Attribute and another value as shown below.  I want to update everything that has 123 with ABC. …

563 views

I have the following query working in my code and now want to move into a separate class as a method that I call with List<Logrecord>, but having trouble determining what TYPE I need to return from …

694 views
Show more content
201506-LO-Top-001
Top Experts In In
LINQ Query
<
Monthly
>

TOP EXPERTS

view all

RELATED TOPICS view all topics

  1. C#
    (91,501)
  2. .NET Programming
    (131,953)
  3. Visual Basic.NET
    (92,137)
  4. ASP.NET
    (123,364)
  5. Microsoft Development
    (47,952)
  6. Microsoft SQL Server
    (157,604)
  7. Query Syntax
    (47,623)
  8. XML
    (20,034)
  9. Programming Languages-Other
    (19,712)
  10. Microsoft SQL Server 2008
    (49,077)