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 …
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 ?????.
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 …
Below is my linq / c# and it return duplicated record. All I need to return one "blue shied"
How can I do that?
I'm creating a DropDownListFor using this code:
This is the LookupGroup values (converted to JSON):
This is the ANSWER_LOOKUP_OPTION_ID value: 9
How can I clear the selected flag …
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 …
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,…
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 …
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 …
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 …
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
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? …
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 :
i want to convert the below Queries from C# to VB.Net:
var results = from p in objStock
group p by p.Model into g
I have a product class and it contains an array of categories.
How can I use linq to query by a provided category?
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
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. …
I have this statement that returns ISBN and Price. How can I look up values on this result?
I am having some difficulties with getting the correct statement in lambda or linq.
select count(me.schools_id) as numOfStudent, schools_name, members_exams_examdate
I have a collection of Product IEnumerable<Product> products.
How can i filter this collection with an IList<string> items using linq.
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 …
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 …
I added a new employee to SQL table.
Add(3, "Issy", "Holm");
And I added this to the List.
Then, check this in the sql db.
I have a DataTable called dt. Now here is what I want …
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 …
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..
So I can use that …