LINQ

Your question is vague. I assume you mean, "How can I look at the results of a LINQ query in the "watch" window in Visual Studio?" For that, add the LINQ query field to the watch window, then call .ToArray() on it. You should be able now to expand the field. Visual Studio may also give you the option to "evaluate results", which will iterate over the IEnumerable results and display them in the debugger. Religiously blogging on the intarwebs since the early 21st century: Kineti L'Tziyon Judah Himango

Hi Dont tell like .include("All.b"); instead tell like .include("b"); This will fix your problem. Thanks , Thani

Hi, Your query should be like SELECT VALUE TOP(20) sSet FROM EveryThing as sSet where sSet.SPERID LIKE '%1020%' AND exists(SELECT VALUE COUNT(A.ADR) FROM sSet.SADDR AS A WHERE A.ADR LIKE '%BOR%')"; If you put the coutn keywork outside then for each sset all the "A" records will be fetched . This will impact performace. Thanks, Thani

You will be happier in the long run if you do Select New With {c, cv}

JimBob SquarePants wrote: Hopefully you'll read this. I did. Thanks for the update. I am glad things are moving along for you now.

Here are Microsoft's most recent VB coding conventions. Brad Abrams also published the C# coding guidelines

If you are interested in digging into the performance of the LINQ query, you can use the CLR profiler. See these interesting links Link 1[^] and Link 2[^]

I think its because you are not specifying the time frame. I think the problem with time part. check it out by giving the time as well and see if the problem still persist. Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions Create .NET Templates

Actually, I made a small mistake in my previous comment. What the C# compiler translates your code to isn't specific to itself...its specific to IL. For example, IL supports the fault block in a try/catch statement, but normal C# code does not. Reflector doesn't really have an option when it encounters a fault in IL...so it puts a fault {} block in the C# code it generates.

Hi, I did, As suggested by you. But, I am getting the same crash for the following query Dim query as integer= (From P In objbase.GetTable(Of table)() Where P.ID1 = Id1 And P.CID1 = CId1 Select P.Fee).SingleOrDefault

Oh yes ... sorry for the spelling mistakes I made... . ;P ;P Abhishek Sur My Latest Articles Basics on LINQ and Lambda Expressions Create .NET Templates

Why dont you use this query? var result = from t in query Select new("id"); Thats it,. I might have mistaken in synatx near new . . .But its just something like that. . And you will get only one column . .

All you need is databinding. . Hope you know the databinding using LINQ. if not tell me i can explain you a bit. .

My bad then, good to know, altough I'm not using express editions. :)

As my experienced , LINQ is easier than ADO.NET. Also, if you learn LINQ you can work with any Data Bases ( like SQL, XML, ... ) with the same query syntax.

Is your GUID column set as the "row guid column"? If not, do so, then the GUID will be auto generated and LINQToSQL will function with IsDBGenerated = true.

Everything you need to know is in Scott Gutheries Excellent LinqToSql series. Part 5 covers the question you ask http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx[^] Cheers Shawty

I assume (as you have not explained) that you want to fix the sequence so that it is correct. ID="15" is out-of-sequence but then so are all the remaining items after it. Unless your example is also wrong. Please explain your objectives. 'Howard