LINQ to SQL announcement
-
Link
Welcome to the forum for discussing LINQ to SQL. A few suggestions:
- Make the subject line specific - "I'm stuck", "HELP" or "This query doesn't work" could easily mean somebody with the answer skipped it.
- Be polite when asking and responding to questions - we're all here to try and help each other
- When you have an answer please remember to mark it as such so people can filter down on who's still stuck and find answers to their problems
There are a few useful resources you also might want to check out:
- MSDN Getting Started & Programming Guide
- Cheat sheet for C# and VB.NET (PDF)
- Customized code-generation templates
- List of additional LINQ to SQL resources
Some other forums that might be of help:
-
1 VotesConditional formatting of LINQ query
l == r) .Select(x => new { n = x.First(), c = ...Unanswered | 5 Replies | 166 Views | Created by Robert1967 - Tuesday, December 3, 2019 9:57 AM | Last reply by Daniel_Zhang-MSFT - Wednesday, December 4, 2019 8:29 AM
-
0 Votes
Is DataContext ExecuteQuery really safe and no Dispose is needed ?
Hi. Our crash repeated few times in a log system. After few hours application crashed without giving us any Fatal exception provided - nothing was logged. Some ...Answered | 8 Replies | 9596 Views | Created by pijaw - Friday, February 25, 2011 4:09 PM | Last reply by smtrejo - Friday, November 29, 2019 12:43 AM -
1 Votes
The Return type for the folloiwng stored Procedure cold not be detected.
hi there i get this issue The Return type for the folloiwng stored Procedure cold not be detected. create PROCEDURE ...Answered | 9 Replies | 5053 Views | Created by Rushdy Najath - Thursday, May 3, 2012 10:52 AM | Last reply by omostan - Thursday, November 28, 2019 5:50 PM -
0 Votes
Linq query outputting curly braces '{ }' in output
x.employees.contractors) .Include(x => x.employees.contractorRoles) .Where(x => x.employees.contractors.Id == ...Answered | 5 Replies | 218 Views | Created by denkyira - Thursday, November 7, 2019 6:38 PM | Last reply by denkyira - Friday, November 8, 2019 5:25 PM -
0 Votes
LINQ - Rows Max Date of Group
I am trying to use LINQ to return a collection of rows, containing only the latest row contained in a group. Sample ...Answered | 2 Replies | 332 Views | Created by nmeek - Tuesday, August 20, 2019 3:38 PM | Last reply by nmeek - Tuesday, August 20, 2019 8:37 PM -
1 Votes
Group By & Max() in LINQ
I usually like to figure stuff out myself, but for some reason I just cant get this. Here's what I'm trying to accomplish using ...Answered | 5 Replies | 55737 Views | Created by captainb8 - Monday, May 12, 2008 7:35 PM | Last reply by Flashhh - Sunday, August 11, 2019 10:55 AM -
0 Votes
How to get all null items greater than 4 months from current date.
x.admintable.registers.Select(wt => wt.adminSurnames)) .Where(x => x.admintable.Id == 45 && x.FinalizedDateTime == null ...Answered | 3 Replies | 386 Views | Created by denkyira - Thursday, August 1, 2019 7:35 PM | Last reply by denkyira - Friday, August 2, 2019 10:58 AM -
0 Votes
Optimizing IEnumerable Linq query
I have a query which is enumerating over and over and taking very long to run. Can somebody help me optimized it. public EmpListItem(IEnumerable<EmployeeTable> ...Answered | 2 Replies | 444 Views | Created by denkyira - Monday, July 22, 2019 7:08 PM | Last reply by denkyira - Saturday, July 27, 2019 9:10 PM -
0 Votes
Avatar of ESCAPE in LINQ to SQL slows significantly _ 0 Points ESCAPE in LINQ to SQL slows significantly Joined Jul 2019 ESCAPE in LINQ to SQL slows significantly's threads Show activity Alert me LINQ to SQL using contains (var) clause generate ESCAPE
[previously posted under the C# forum, and someone mention that this the more appropriate forum, so here it is] I have added a "contains (searchVar)" ...Unanswered | 1 Replies | 390 Views | Created by ESCAPE in LINQ to SQL slows significantly - Monday, July 15, 2019 7:14 PM | Last reply by Viorel_ - Monday, July 15, 2019 7:42 PM -
0 Votes
Really need help with this LINQ Query using inheritance.
(d.c.Status == "Sold"), // etc.. a few more counts // NOW I need to get all Cars that are SUV and HasPremium and do a Sum the SUV value ...Unanswered | 3 Replies | 480 Views | Created by MVCNewb - Monday, July 8, 2019 5:38 PM | Last reply by Kyle Wang - MSFT - Wednesday, July 10, 2019 9:58 AM -
0 Votes
Compare two dates C#
I am trying to output a sequence of dates with Inclusive of the ending date. For some reasons if the Day part of the starting date is greater than the Day part of the End Date, the end date is not ...Answered | 2 Replies | 517 Views | Created by denkyira - Wednesday, June 19, 2019 1:59 PM | Last reply by denkyira - Thursday, June 20, 2019 1:00 PM -
0 Votes
LINQ to SQL with variable column name
0 Then strList = strArray.ToList End If Return strList End FunctionAnswered | 5 Replies | 7934 Views | Created by ToddMiller - Friday, January 3, 2014 8:09 PM | Last reply by daverud - Wednesday, June 19, 2019 4:15 PM -
0 Votes
Alter View -Two New Feilds Adding
Hello All, We have a view that is created on the DB to bring in all the records for a request into a single column . Below is the ...Unanswered | 1 Replies | 443 Views | Created by Jim03_Jim03 - Monday, June 17, 2019 3:09 PM | Last reply by Kyle Wang - MSFT - Tuesday, June 18, 2019 9:40 AM -
1 Votes
Linq-To-SQL 2019 and Beyond
Hi all, I was wondering what the future was for Linq-To-SQL. Is it something that Microsoft plan to keep around given its popularity? The company I am currently working for has a ...Unanswered | 8 Replies | 2032 Views | Created by cbertrand78 - Monday, January 28, 2019 9:26 AM | Last reply by FlashBFE - Tuesday, June 11, 2019 12:25 PM -
0 Votes
Help with Find and Include Linq
Please bare with me. I am trying to understand the Linq language. I am to to this. Here is the codefirstMVC codes with 2 tables related to each other by TeamName ...Answered | 3 Replies | 447 Views | Created by d052057 - Monday, June 10, 2019 5:01 PM | Last reply by d052057 - Tuesday, June 11, 2019 1:57 AM -
0 Votes
How do I do this in LINQ
x.Status != "Sold"), Count2 = // Code here that will allow me to use "ownerGrp" purchase date. example if Purchase date is less than ...Answered | 2 Replies | 455 Views | Created by MVCNewb - Friday, June 7, 2019 1:29 PM | Last reply by MVCNewb - Monday, June 10, 2019 12:21 PM -
0 Votes
System.InvalidCastException: 'Specified cast is not valid.'
Hi i am creating a IT Inventory application in visual studio community 2017 , the code is in asp.net / C#. When i submit the data to the SQL table i received this ...Proposed | 1 Replies | 979 Views | Created by Jason Kleinhans - Tuesday, May 21, 2019 6:50 PM | Last reply by ckJustReading - Tuesday, May 21, 2019 7:26 PM -
0 Votes
I need help with complex LINQ to XML query
I don’t know if the query I am trying to do is even possible but if one of you LINQ to SQL/XML guru’s can figure this out I will be so thankful and salute you as a LINQ God. My end goal is ...Answered | 3 Replies | 531 Views | Created by NEW2BI - Tuesday, May 14, 2019 4:54 PM | Last reply by Kyle Wang - MSFT - Thursday, May 16, 2019 1:16 AM -
5 Votes
LINQ select distinct c#
I'm trying to do a query that does not include repeated IdUser values, but does not work. this is my linq ...Answered | 8 Replies | 160317 Views | Created by CADAVID - Thursday, July 26, 2012 4:44 PM | Last reply by mtsiakiris - Monday, May 6, 2019 10:12 AM -
0 Votes
Get the Fourth (4th) Friday of each month
I am trying to get the fourth (4th) Friday using the code below but it is giving me the last Friday. The fourth Friday of May for example is 24th 2019. Below is my code. Any ...Answered | 2 Replies | 566 Views | Created by denkyira - Wednesday, April 24, 2019 10:15 PM | Last reply by denkyira - Thursday, April 25, 2019 10:29 AM - Items 1 to 20 of 4865 Next ›
LINQ to SQL announcement
-
Link
Welcome to the forum for discussing LINQ to SQL. A few suggestions:
- Make the subject line specific - "I'm stuck", "HELP" or "This query doesn't work" could easily mean somebody with the answer skipped it.
- Be polite when asking and responding to questions - we're all here to try and help each other
- When you have an answer please remember to mark it as such so people can filter down on who's still stuck and find answers to their problems
There are a few useful resources you also might want to check out:
- MSDN Getting Started & Programming Guide
- Cheat sheet for C# and VB.NET (PDF)
- Customized code-generation templates
- List of additional LINQ to SQL resources
Some other forums that might be of help:
