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 Votes[Announcement] "LINQ to SQL" Forum will be migrating to a new home on Microsoft Q&A!
This "LINQ to SQL" Forum will be migrated to a new home on Microsoft Q&A! We've listened to your feedback on how we can enhance the forum ...
Found 4900 threads
-
1 Votes
SQL External Table creation in SQL Server 2017 and CSV files are located at local Drive example: D:\Extenal_tables\text.csv
Hello Team, I am trying to create SQL External table creation using CSV files are located at local Drive exp: D:\Extenal_tables\text.csv and I am not ...Unanswered | 1 Replies | 485 Views | Created by Ravi Madanu - Thursday, December 10, 2020 4:09 PM | Last reply by Daniel_Zhang-MSFT - Friday, December 11, 2020 5:31 AM -
0 Votes
linq query doesnt afftect the select statement
hi , I have method like below public List<TEntity> GetEntityList(Expression<Func<TEntity, bool>> filter = null) ...Unanswered | 7 Replies | 601 Views | Created by Aly14 - Saturday, November 28, 2020 4:06 PM | Last reply by Daniel_Zhang-MSFT - Wednesday, December 2, 2020 8:28 AM -
0 Votes
SSIS Package gets success in Catalogue and gets failed in SQL Agent Job
SQL Package deployed in SSISDB Catalogue ,. It is running successfully in Catalogue, Getting failed while the same package runs in SQL Agent ...Answered | 2 Replies | 485 Views | Created by govindarajp91 - Friday, November 20, 2020 12:32 PM | Last reply by Daniel_Zhang-MSFT - Monday, November 23, 2020 7:19 AM -
0 Votes
[Announcement] "LINQ to SQL" Forum will be migrating to a new home on Microsoft Q&A!
This "LINQ to SQL" Forum will be migrated to a new home on Microsoft Q&A! We've listened to your feedback on how we can enhance the forum ... -
1 Votes
Special characters in SQL Editor
I am SSIS reading data from EXEL, there were error in one column. When i analysed the data looks normal NORMAL4 ABC), when the same value is selected in sql editor ...Discussion | 1 Replies | 541 Views | Created by govindarajp91 - Monday, November 9, 2020 12:09 PM | Last reply by Viorel_ - Tuesday, November 10, 2020 11:05 AM -
1 Votes
Change table column decimal precision
I have a datatable table. I need to increase a column precision, decimal (5, 2) to decimal (6, 2). My table has a lot of records already. Can I use this in SQL 2012: Alter ...Answered | 1 Replies | 592 Views | Created by 98108 - Monday, November 9, 2020 5:39 PM | Last reply by Daniel_Zhang-MSFT - Tuesday, November 10, 2020 7:36 AM -
0 Votes
Sorting the text data
Hi I have a column in which the data is in string format shown in below image ( Column A). The out put should be sorted from lower to bottom with space in between. ( i.e 102 ...Unanswered | 4 Replies | 783 Views | Created by Fareed37 - Wednesday, October 21, 2020 6:13 PM | Last reply by Viorel_ - Friday, October 23, 2020 4:21 PM -
0 Votes
Netezza + bucketing
Hi Good day!! I have below wo tables and having respective orders. need an output as per the right output table. Kindly help in getting the output. I have ...Unanswered | 1 Replies | 694 Views | Created by Fareed37 - Thursday, October 22, 2020 9:44 AM | Last reply by Daniel_Zhang-MSFT - Friday, October 23, 2020 8:49 AM -
0 Votes
derive buckets from different date fields
Hi, I have around 4 different columns with dates in it and these columns are string/varchar data types.. need to derive a column from these 4 fields call it as ...Unanswered | 1 Replies | 582 Views | Created by SQLServerRaj - Thursday, October 22, 2020 4:00 PM | Last reply by Daniel_Zhang-MSFT - Friday, October 23, 2020 3:01 AM -
2 Votes
Many to Many tables relationship LINQ
Let's say that I have three tables: CategoriesSubCategoriesCategories_SubCategories (including many to many relationships within the previous tables) Like the ...Unanswered | 4 Replies | 900 Views | Created by Claudio M. E. Bastos Iorio - Monday, October 12, 2020 7:42 AM | Last reply by Daniel_Zhang-MSFT - Monday, October 19, 2020 1:05 AM -
0 Votes
creating database
Hello, I use following command to create database CREATE DATABASE [MEDWSL] ON (NAME = N'MEDWSL', FILENAME = N'C:\ICMSDATA\MEDWSL.MDF' , SIZE = 2, FILEGROWTH ...Unanswered | 1 Replies | 645 Views | Created by Tariq Iftikhar - Friday, October 16, 2020 6:58 PM | Last reply by Viorel_ - Saturday, October 17, 2020 8:22 AM -
1 Votes
Date - Netezza ---SQL Query
Logic is nvl(Actual end_date, End date)> Todays date -->then in_business ELSE Out of business. For IN_Business ...Answered | 4 Replies | 1079 Views | Created by Fareed37 - Tuesday, October 13, 2020 10:45 PM | Last reply by Fareed37 - Thursday, October 15, 2020 5:38 AM -
1 Votes
Transact SQL with ASP.Net app. Notification email
I am using the below code in a trigger. Everything works fine except I need to separate the lines. The email looks like this when it hits the inbox: The 5081 is actually the id of ...Answered | 8 Replies | 842 Views | Created by webdesignernotcoder - Monday, October 12, 2020 5:07 PM | Last reply by webdesignernotcoder - Wednesday, October 14, 2020 1:11 PM -
4 Votes
Netezza Query (M+S+T)
Hi All, I am using netezza as a database to run my queries, i have below input ( highlighted in Green) basted on the following ...Answered | 6 Replies | 920 Views | Created by Fareed37 - Friday, October 9, 2020 3:11 AM | Last reply by Daniel_Zhang-MSFT - Monday, October 12, 2020 8:11 AM -
12 Votes
Mobile +SIM ( SQL QUERY)
5 Mobiles & 3 SIMS O/p I need is Mobile count -- 2, Mobile + SIM -- 3, SIM -- 0 Customer 2 ---> 2 Mobiles & 3 SIMS O/p I need is Mobile Count --0, Mobile +SIM ...Answered | 9 Replies | 975 Views | Created by Fareed37 - Wednesday, October 7, 2020 3:36 AM | Last reply by Fareed37 - Friday, October 9, 2020 2:45 AM -
0 Votes
SQL SERVER 2012 T-SQL
Hi, Please provide me the query to get output from the below table. Table: 1 abc ...Proposed | 1 Replies | 649 Views | Created by nrajeshkumars - Tuesday, October 6, 2020 6:14 AM | Last reply by Viorel_ - Tuesday, October 6, 2020 10:43 AM -
0 Votes
How to find one ID with many names
Hi Could you please tell me how to find one ID with many names or one name with many IDs? Thanks zjUnanswered | 1 Replies | 673 Views | Created by ZaraJ - Thursday, October 1, 2020 5:25 PM | Last reply by Daniel_Zhang-MSFT - Friday, October 2, 2020 6:12 AM -
0 Votes
how convert lambda expression to sql
Hi All. How to convert this lambda expression to SQL select List<int> empIds = context.EmpDeptartments.Where(ed => ed.GroupId == groupid).Select(ed => ...Answered | 4 Replies | 977 Views | Created by zleug - Wednesday, September 23, 2020 10:11 PM | Last reply by zleug - Thursday, October 1, 2020 1:25 AM -
0 Votes
Linq To sql- same value returned after an update
t.AccountID == AccountID); decimal? accountBalance = account.Balance == null ? 0 : account.Balance; context.UpdateLog(tranID, "Added1:accountID:" + ...Unanswered | 5 Replies | 837 Views | Created by want 2 Learn - Sunday, September 27, 2020 3:56 PM | Last reply by Daniel_Zhang-MSFT - Wednesday, September 30, 2020 5:31 AM -
0 Votes
SQL Select with condition
Hi, in my sql table, there is a column which have string of text. For example Column0 2ABF ...Answered | 4 Replies | 1119 Views | Created by ddee - Friday, September 18, 2020 8:59 PM | Last reply by ddee - Tuesday, September 29, 2020 12:56 PM - Items 1 to 20 of 4900 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:
