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:
-
0 VotesTrying to convert/translate a Linq Query to a T Sql Query
!string.IsNullOrEmpty(a.DeptHL) && (a.AppCI.DispositionID != null && a.AppCI.AppDisposition.Disposition != "Retire") && ...Answered | 4 Replies | 50 Views | Created by Rich P123 - Thursday, October 05, 2017 3:50 PM | Last reply by Rich P123 - Friday, October 06, 2017 3:02 PM
-
0 Votes
LINQ style queried directly in SQL
High level Q: Will we ever be able to use LINQ style join queries directly in SQL? is it in the pipeline or will we forever have to use joins?Unanswered | 1 Replies | 65 Views | Created by SullSull - Wednesday, September 27, 2017 2:19 PM | Last reply by Bob Ding - Thursday, September 28, 2017 7:00 AM -
0 Votes
How to write FULL JOIN in C# using LINQ
Hi Team, I am rewriting the below SELECT statement (part of Stroed Procedure) to C# using LINQ Could you please help me on "FULL ...Proposed | 3 Replies | 469 Views | Created by Obuliraj - Wednesday, March 01, 2017 1:22 AM | Last reply by Bob Ding - Tuesday, September 26, 2017 2:24 AM -
0 Votes
Name ServerList doesn't exist in current context error
How to initialize the linq query in MVC . I am getting error " Name ServerList doesn't exist in current context error " public ActionResult ...Answered | 1 Replies | 103 Views | Created by asif300 - Tuesday, September 19, 2017 9:25 PM | Last reply by Bob Ding - Wednesday, September 20, 2017 6:27 AM -
0 Votes
clashing versions of mysql.data
I'm getting the error below when trying to update a table via the designer. It happened after I upgraded mysql.data to 6.9.9.0. I tried to manually erase the older version from the privateassemblies ...Unanswered | 1 Replies | 84 Views | Created by oferst24 - Tuesday, September 19, 2017 8:51 AM | Last reply by Bob Ding - Tuesday, September 19, 2017 11:58 AM -
3 Votes
Rank with Linq
Suppose I have a sql table of orders that looks something like this:- Salesman, OrderID, ...Unanswered | 7 Replies | 17628 Views | Created by AndrewJones123543 - Thursday, August 14, 2008 8:42 PM | Last reply by YowzaPoker - Tuesday, September 19, 2017 4:43 AM -
0 Votes
SubmitChanges does not work unless using Integrated Security connection
b.bookId == id).Single(); book.Name = "newName"; ...Proposed | 2 Replies | 224 Views | Created by Franklin F. Wang - Thursday, June 08, 2017 6:42 PM | Last reply by Franklin F. Wang - Friday, September 01, 2017 8:16 PM -
0 Votes
Question on "Group Join" Syntax
Could someone please explain the following syntax. Question 1: I am guessing that the following Linq query joins the two tables on the 'state' field and loads the results ...Answered | 1 Replies | 128 Views | Created by Duckkiller53 - Tuesday, August 22, 2017 3:48 PM | Last reply by cole wu - Wednesday, August 23, 2017 2:29 AM -
0 Votes
How to Get data
For example I have 3 class public class Enterprise ...Proposed | 1 Replies | 142 Views | Created by Ahlompys - Monday, August 21, 2017 10:18 AM | Last reply by cole wu - Tuesday, August 22, 2017 2:02 AM -
0 Votes
Question on the Key word Function
x.Exclude != 1) Question 2. Does the code .GroupBy(Function(g) Return New With {Key .EmpID = g.EmpID} End Function. Create a new object of one field ...Answered | 2 Replies | 122 Views | Created by Duckkiller53 - Tuesday, August 15, 2017 1:15 PM | Last reply by Duckkiller53 - Tuesday, August 15, 2017 2:17 PM -
0 Votes
SQL bit to 1 0 using linq
Hi, Making web API and from datamodel in SQL DB I have values in bit-type and I want to show them 1 or 0 as end result. SQL bit maps to C# bool and ...Answered | 3 Replies | 138 Views | Created by varolevy - Friday, August 11, 2017 11:36 AM | Last reply by varolevy - Monday, August 14, 2017 6:02 AM -
0 Votes
LInq and XML
I have the following XML form which is coming back form Amazon S3 bucket list and I want to use linq to query the Bucket names but because it the second level down it seems to be failing to find the ...Answered | 1 Replies | 106 Views | Created by Dagz - Friday, August 04, 2017 4:24 PM | Last reply by Viorel_ - Monday, August 07, 2017 4:42 AM -
0 Votes
GROUP BY & Top 1 Question
= fromDate.Date && messages.CreatedOnProposed | 2 Replies | 157 Views | Created by Steven Aiello - Wednesday, August 02, 2017 6:20 PM | Last reply by cole wu - Friday, August 04, 2017 2:55 AM -
0 Votes
Error_BC30456_' is not a member of 'String
I got that error: Severity Code Description Project File Line Suppression State Error BC30456 'ToExclaim' is not a member of ...Answered | 5 Replies | 187 Views | Created by agatha soc - Thursday, July 20, 2017 1:48 PM | Last reply by agatha soc - Saturday, July 29, 2017 8:39 PM -
0 Votes
Linq replace a value of one column with another on the same Table
f.User_Id.Equals(OldUserId)) .ToList(); model.ForEach(f => f.User_Id = NewUserId); If NewUserId is already ...Answered | 3 Replies | 159 Views | Created by denkyira - Monday, July 24, 2017 2:49 PM | Last reply by denkyira - Tuesday, July 25, 2017 6:11 PM -
0 Votes
linq error
I'm trying to make a simple query, to get to know Linq better, but there's an error that I can not identify.Answered | 3 Replies | 208 Views | Created by agatha soc - Wednesday, June 28, 2017 12:37 AM | Last reply by agatha soc - Sunday, July 09, 2017 11:56 PM -
0 Votes
LINQ and Count
I have the following, at the moment I retrieve the reader with the strongest signal, what I want to do is exclude any reader which does not have 4 entries in the memory The list is ...Unanswered | 1 Replies | 157 Views | Created by Darren Rockett - Thursday, July 06, 2017 3:27 PM | Last reply by cole wu - Friday, July 07, 2017 10:02 AM -
0 Votes
linq problems
I'm trying to make a simple query, to get to know Linq better, but there's an error that I can not identify. I'm following a book and it seems all right. See the error ...Proposed | 7 Replies | 293 Views | Created by agatha soc - Wednesday, June 21, 2017 8:37 PM | Last reply by cole wu - Wednesday, June 28, 2017 1:06 AM -
0 Votes
SQL to LINQ question - using Except
! BASE.AsEnumerable().Any (rb => rb.c2 == ra.c2, rb => rb.c3 == ra.c3, rb => rb.c4 == ...Unanswered | 1 Replies | 177 Views | Created by laszlom - Friday, June 23, 2017 5:27 PM | Last reply by Viorel_ - Saturday, June 24, 2017 5:17 PM -
0 Votes
Implicit Transaction for Stored Procedure Calls?
I know that an implicit transaction gets made for submits but does one also get made for calls to stored procedures? I've been having problems with timeout issues on a stored ...Answered | 3 Replies | 213 Views | Created by Zloth X - Thursday, May 04, 2017 3:47 PM | Last reply by Zloth X - Friday, June 02, 2017 9:01 PM - Items 1 to 20 of 4790 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:
