No announcements
Found 2768691 threads
-
6 VotesHOW TO USE 'IN' clause in linq
hi ...... i am working wiht VS 2010 AND beginner in LINQ . how to use SQL 'IN' Clause in Linq ...Answered | 3 Replies | 60762 Views | Created by RageshShiva - Saturday, June 25, 2011 4:51 AM | Last reply by Fernando Soto - MCSD - Saturday, July 2, 2011 1:39 PM
-
0 Votes
How to use IN operator in LINQ
how can i use following query in LINQ DECLARE @TotalPaid DECIMAL(23,2)SELECT @TotalPaid = SUM(Amount) FROM dbo.EnrolmentPaymentWHERE PaymentType ...Answered | 1 Replies | 3764 Views | Created by MAHMOOD AHMAD TAHIR - Wednesday, February 11, 2009 12:38 PM | Last reply by Joe Albahari - Wednesday, February 11, 2009 1:18 PM -
1 Votes
how to dynamic linq
hi how to create Dynamic query Builder with linq in runtime please help me it's urgentAnswered | 3 Replies | 1582 Views | Created by vahidbakhtiary - Tuesday, August 9, 2011 7:15 AM | Last reply by Noam B - Wednesday, August 10, 2011 7:23 AM -
2 Votes
Joining multiple tables with LINQ to Dataset, selecting the columns explicitly removes the CopyToDataTable of the result
IEnumerable(Of Anonymous()) type. The CopyToDataTable will not work with this type because it copies DataRow objects and not Anonymous type objects. In order to do what you need you ...Answered | 5 Replies | 3895 Views | Created by Chibbie123 - Wednesday, February 8, 2012 2:14 AM | Last reply by Fernando Soto - MCSD - Friday, February 10, 2012 4:50 AM -
0 Votes
How to use NOT IN in LINQ ?
= item, Name = item.ToString().PadLeft(10, '0') }); // The EmployeeIds you dont want to take (NOT IN set) var notWanted = new[] { 1, 5, 10, 34, 25, 75 }; // The query, ...Answered | 2 Replies | 1945 Views | Created by lax4u - Friday, June 28, 2013 6:43 PM | Last reply by Syed Amjad (MCC) - Sunday, June 30, 2013 6:33 AM -
1 Votes
How to use "Union" in LINQ
, after translation, the generated T-SQL may become more complex, it will certainly affect the performance. More information about how to execute T-SQL and Stored Procedure ...Answered | 1 Replies | 3461 Views | Created by nmittapalli - Wednesday, May 16, 2012 9:41 AM | Last reply by Allen_MSDN - Saturday, May 19, 2012 6:18 AM -
2 Votes
How the LINQ works?
I think you should compile code with LINQ query and look with Reflector how the compiler translates your code.Answered | 5 Replies | 3437 Views | Created by peterxxx - Wednesday, April 16, 2008 10:56 AM | Last reply by MatthieuMEZIL - Wednesday, April 16, 2008 5:13 PM -
0 Votes
How LINQ really works
I agree. I have only used LINQ a few times and it was basically to see how it works and to use the whole pack with DataContexts, DataBases and TableAdapters. In this last ...Answered | 6 Replies | 2960 Views | Created by GurunGuns - Monday, March 8, 2010 1:19 PM | Last reply by Zeigon - Wednesday, March 10, 2010 3:14 PM -
0 Votes
how to loop in LINQ
teams / col(0). To limit it add additional where - tha can also be found in my first post. If you have problems to understand the expressions have a look ...Answered | 14 Replies | 847 Views | Created by newandold - Tuesday, May 14, 2013 9:41 AM | Last reply by Elmar Boye - Sunday, May 19, 2013 8:02 PM -
3 Votes
How return max value in LINQ, please?
How to: Find the Maximum Value in a Numeric Sequence (LINQ to SQL)Answered | 2 Replies | 102971 Views | Created by rcmsft - Tuesday, March 4, 2008 4:26 PM | Last reply by Lentucky - Thursday, July 8, 2010 7:57 PM -
0 Votes
How to check NULL in LINQ queries?
I have long Linq query which involves several entity objects. In the query below any of the entity object could be null. Whats the prefered way to check null // iAnswered | 1 Replies | 27984 Views | Created by lax4u - Monday, August 20, 2012 3:18 PM | Last reply by Alexander Sun - Tuesday, August 21, 2012 2:42 AM -
0 Votes
how to if exists in linq query
; where tbl2.id=12 && tbl1.line=mcnt.line ) and i'll implement it with linq please help me ...Answered | 2 Replies | 690 Views | Created by vahidbakhtiary - Monday, October 7, 2013 8:10 AM | Last reply by vahidbakhtiary - Monday, October 7, 2013 8:29 AM -
0 Votes
How to do inline query in linq.
Hello, I have a query with an inline query, which I am not sure how to translate into a linq query. I am trying to get a list of items from a ...Answered | 2 Replies | 6076 Views | Created by ShaunMS - Thursday, April 28, 2011 8:38 PM | Last reply by Alan_chen - Tuesday, May 3, 2011 5:31 AM -
0 Votes
how to use function in LINQ query
Hi All, I've a public function defined in vb.net to decrypt the input string. how can i use this function in LINQ query ...Answered | 1 Replies | 4250 Views | Created by venky_ind - Thursday, October 7, 2010 3:36 AM | Last reply by Syed Mehroz Alam - Thursday, October 7, 2010 6:19 AM -
0 Votes
how to implement inheritance in Linq?
in my new DB, why? how it should go to support inheritance in Linq? i really need it.Answered | 2 Replies | 3578 Views | Created by Michael.Young - Thursday, August 2, 2007 1:12 AM | Last reply by TikiWan - Thursday, August 2, 2007 3:29 PM -
1 Votes
Get Unique FormattedValues from DataGridViewColumn using LINQ VB.NET (LINQ Experts Needed)
. FormattedValues) don't sort properly in order. Is it possible to add my other columns in one LINQ statement? I need to convert ...Answered | 3 Replies | 6629 Views | Created by Ryan0827 - Tuesday, June 12, 2012 2:28 AM | Last reply by Mike Feng - Friday, June 15, 2012 6:38 AM -
0 Votes
Linq to Excel - how?
Use the Linq to Excel project to query data from Excel spreadsheets using Linq statements. Below is an example of how easy it is to use.Answered | 4 Replies | 13449 Views | Created by Dr Griff - Tuesday, May 6, 2008 4:19 PM | Last reply by Paul Yoder - Friday, November 20, 2009 5:39 PM -
0 Votes
LINQ in CLR Integration
Hi Diego, I understand its been a while since the post.. I am trying to enable Linq to Objects in my 2008 SQL CLR project. How exactly would I do that? ...Answered | 3 Replies | 10349 Views | Created by Arjuna_M - Saturday, May 10, 2008 4:28 AM | Last reply by Orry Rotem - Wednesday, March 31, 2010 5:31 PM -
0 Votes
Get data from datatable with LINQ
Hi Ilimax68; In order to use CopyToDataTable from a Linq query the results of that query needs to be IEnumerable(Of DataRow). So as is ...Answered | 7 Replies | 11771 Views | Created by Ilimax68 - Tuesday, December 11, 2012 2:27 PM | Last reply by Ilimax68 - Wednesday, December 12, 2012 1:36 PM -
0 Votes
Make percentage in Linq
hi, anyone know how to make percentage in linq? There are different ways to do it, i did it follow ...Answered | 1 Replies | 2750 Views | Created by folkrox - Sunday, June 10, 2012 7:57 AM | Last reply by Syed Amjad (MCC) - Sunday, June 10, 2012 10:26 AM
No announcements
