ScottGu's Blog

# re: LINQ to SQL Debug Visualizer

Of course it helps. Everything you do helps.

# re: LINQ to SQL Debug Visualizer

Hello Scott,

thank you! But I'm wondering if it's so easy to extend the studio for debugging, why don't you put in also more refactoring while designing? The VS is very basic in this recard, see the resharper as an example(www.jetbrains.com/resharper), it would be so cool to have all the refactoring w/out needing 3rd parties for basic use cases like relocating classes, searching for files, class shortcuts etc. etc. To refactor a bigger project using VS w/out some additional tool hurts.

Thank you,

Andrej

# re: LINQ to SQL Debug Visualizer

I'm loving this VS2008 series as I'm testing the new build this week. Thanks Scott

Cheers

Al

# re: LINQ to SQL Debug Visualizer

Hi Scott,

maybe this is a stupid question, but I've not yet found a "supported databases by linq" page.

which databases linq support? is MS Access supported for example?

bye

Lenny76

# re: LINQ to SQL Debug Visualizer

Hi Scott,

Do you have a plan for beta 3?If you have,when is it release?Or what is the next edition of vs2008?

# re: LINQ to SQL Debug Visualizer

I am wondering performance issue while using LINQ. Is there any performance issue between using LINQ and without using LINQ?

# re: LINQ to SQL Debug Visualizer

Continue above,why I can't find "JavaScript" item in "tools-options-TextEditor"?

# re: LINQ to SQL Debug Visualizer

I think you might as well make the visualizer a part of the standard install for VS 2008.

With all the talk about LINQ to SQL I'm not sure I understand this: is there no LINQ to Access, or LINQ to Oracle? Or is that not the way it works?

# re: LINQ to SQL Debug Visualizer

Does this only work in C#? I have it working in C# but in VB.Net the visualiser just shows the results of the query

# re: LINQ to SQL Debug Visualizer

It works great with C# but have anybody an idea why isn't this visulizer doesn't work with VB?

# re: LINQ to SQL Debug Visualizer

Hey Scott,

How is this implemented?

Any pointers on how to implement this on my own LINQ provider?

Thanks again,

Zombie

# Using LINQ to SQL

Hi, Scott Guthrie, wrote a series of blog posts titled “ Using LINQ to SQL ”. Go have a look here . To

# re: LINQ to SQL Debug Visualizer

Is this going to be in the RTM?

# re: LINQ to SQL Debug Visualizer

Is there a way to debug the LINQ code being executing within the LinqDataSource? When I try to duplicate your seemingly simple demos with timestamp fields added, I get various errors. Is there a way see the source code being executed behind the scenes to understand what is causing the errors?

# re: LINQ to SQL Debug Visualizer

Hi Scott,

I tried installing the visualizer on a 64 bit system, without much luck unfortunately.

I dropped the dll in both of the following location:

C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\x86

C:\Program Files\Microsoft Visual Studio 9.0\Common7\Packages\Debugger\X64

You got any suggetions to what the problem might be.

Brgds.

Christian

# re: LINQ to SQL Debug Visualizer

Hi Scott,

There was a DataShape and Include methods in Beta 1 that were used when we don't want to allow deferred loading! what happened to this object/Method in Beta 2? is there an online place to check changes?

Thanks

# re: LINQ to SQL Debug Visualizer

Another good blog on LINQ to SQl. But can we have a project download we are using the LINQ to SQl in the data acces layer.

What will be the data type that I will pass back when I am using a LINQ query in a function.(I want to return the value retrieved from the LINQ query back)

In the same condition above if I want to send only 2 of the 4 column what data type to be used to return the value of the LINQ query?

# re: LINQ to SQL Debug Visualizer

Hey Scott,

How does the performance of LINQ stand against running a SQL QUery that returns a result set saved to an IList?

I'm thinking in turns of, if 1,000 of these statements were ran every second, which one would be faster, and use less memory?

Thanks,

Ryan.

# re: LINQ to SQL Debug Visualizer

Any reason this is not part of the VS 2008 install?  Will it be at some point in the future?

Thanks.

# re: LINQ to SQL Debug Visualizer

Hi Scott;

>>- with the next release of VS you should see considerable improvements there.<<

When you say "Next release", are you referring to Beta 3 or RC or RTM or are you referring to future major upgrades like VS2009 0r VS2010?

I thought you had mentioned (long time ago) that you're more likely going to do videos than blog. Or hopefully someone else will do some lengthy videos on datacontext, and all the relevant info like locking, transaction, life span of DC, "Events" and so on. Do you know if any thing is cooking for a series of formal Linq videos?

Thanks!

# re: LINQ to SQL Debug Visualizer

I've now got my data context suppling data to a data grid view in a windows forms project. Can i use it to supply data to a WPF Grid in a WPF project?

# re: LINQ to SQL Debug Visualizer

Sql Visualizer , surely rocks in terms of debugging LINQ queries, it reminds me of Sql Profiler in right in Visual studio.

In addition , i want to ask, the queries generated by LINQ, how can i optimize that more, let say,i want to select some products on basis of a fixed criteria, and i know that Index A has the best coverrge, how can i forcely specify the index, right in LINQ query?Will there be something like the following in future.

var query = from p in db.Products

           where p.OrderDetails.Count > 5

           with index p.OrderDetail_Index

           select p;

Also it will be nicer to know , how to implement , RANK, CTE , using LINQ

# re: LINQ to SQL Debug Visualizer

|Hi Ryan,

|>>>>>>> How does the performance of LINQ stand against running a SQL QUery that returns a |result set saved to an IList?  I'm thinking in turns of, if 1,000 of these statements were |ran every second, which one would be faster, and use less memory?

|LINQ to SQL is very fast.  If you are surfacing an object model for your data (meaning |creating objects to represent relational data), I think you'll find LINQ to SQL is about as |efficient as if you did it completely by hand.

|If you use a compiled LINQ to SQL query, you'll find with beta2 that it is about 93% the |performance of iterating over a raw SQLDataReader object: |blogs.msdn.com/.../linq-to-sql-rico-drops-the-other-shoe.aspx

Scott, that's pretty amazing. Instead of having 600+ stored procedures (which we have :P ) you could have your DataBase as an actual layer in code, and you could build your data access layer totally out of LINQ, eliminating Stored Procedures and Functions.

Very interesting, as I doubt people will want to create a solution of 1/2 LINQ and 1/2 Stored Procedures - it would get messy. Time to play :)

Interesting.

# re: LINQ to SQL Debug Visualizer

I have been using a similar tool (llblgen), and there is an improvement you can make that would make the query visualizer superior.

Can you do a textual parameter replacement in the query, so I can just copy the query to a query tool and run it without modification?

In your example I would have to search for @p0 and replace it with 'Beverages' which can be cumbersome with, say, 15 parameters...

Yours,

Tony Stratton

# re: LINQ to SQL Debug Visualizer

Thanks Scott!!

Regards

# LINQ to SQL Debug Visualizer

Another great post from Scott Guthrie about installing and using the Linq to SQL Debug Visualizer ..

# re: LINQ to SQL Debug Visualizer

Hey Scott,

Love the new VS2008 it’s awesome. I have been finding some minor bugs during use but when I try to report them at:

connect.microsoft.com/visualstudio

It puts me in a infinite loop.

After doing the requested login.

It tells me I don’t have access to submit a bug but I when I got available connections section is says I do?

  I don’t want to bother with such a minor bug as array index notation not working properly.

Am I not looking at the right place to submit bugs?

    Thanks for everything seriously I don’t remember what programming was like before your blog,

  G

# links for 2007-08-01 &laquo; Inferis&#8217; Mind Dump

Pingback from  links for 2007-08-01 &laquo; Inferis&#8217; Mind Dump

# re: LINQ to SQL Debug Visualizer

Scott,

Can you give us an update on the compatability with vb.net.

Thanks

Ken

# re: LINQ to SQL Debug Visualizer

HI Scott,

Thanks fo9r the explanation. That was very helpful

# re: LINQ to SQL Debug Visualizer

Have issue with deleting a record. The where statement below seems a bit strange "WHERE 0 = 1".

SELECT [t0].[SSNum], [t0].[FirstName], [t0].[LastName], [t0].[MiddleName], [t0].[LastEditDate], [t0].[CreationDate], [t0].[HireDate], [t0].[ExitDate], [t0].[Active], [t0].[RawImage2], [t0].[RawImage3], [t0].[Picture], [t0].[Attachment], [t0].[Template1], [t0].[Template2], [t0].[Template3]

FROM [dbo].[Employees] AS [t0]

-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1

DELETE FROM [dbo].[Employees] WHERE 0 = 1

-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1

SELECT [t1].[value]

FROM (

   SELECT @p0 AS [value], [t0].[SSNum]

   FROM [dbo].[Employees] AS [t0]

   ) AS [t1]

WHERE [t1].[SSNum] = @p1

-- @p0: Input Int32 (Size = 0; Prec = 0; Scale = 0) [0]

-- @p1: Input StringFixedLength (Size = 9; Prec = 0; Scale = 0) [111111111]

-- Context: SqlProvider(Sql2005) Model: AttributedMetaModel Build: 3.5.20706.1

**********************************************************

System.Data.Linq.ChangeConflictException was unhandled

 Message="Row not found or changed."

 Source="System.Data.Linq"

 StackTrace:

      at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)

      at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)

      at PunchMeIn.TestForm.employeeBindingNavigatorSaveItem_Click(Object sender, EventArgs e) in C:\Documents and Settings\Administrator\My Documents\Visual Studio Codename Orcas\Projects\VSMacros80\PunchMeIn\TestForm.cs:line 28

Table

----------------------------------

CREATE TABLE [dbo].[Employees](

[SSNum] [nchar](9) NOT NULL,

[FirstName] [nvarchar](50) NOT NULL,

[LastName] [nvarchar](50) NOT NULL,

[MiddleName] [nvarchar](50) NULL,

[LastEditDate] [datetime] NULL,

[CreationDate] [datetime] NULL,

[HireDate] [datetime] NULL,

[ExitDate] [datetime] NULL,

[Active] [bit] NOT NULL CONSTRAINT [DF_Employees_Active]  DEFAULT ((1)),

[RawImage1] [varbinary](max) NULL,

[RawImage2] [varbinary](max) NULL,

[RawImage3] [varbinary](max) NULL,

[Picture] [varbinary](max) NULL,

[Attachment] [varbinary](max) NULL,

[Template1] [varbinary](max) NULL,

[Template2] [varbinary](max) NULL,

[Template3] [varbinary](max) NULL,

CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED

(

[SSNum] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

# { null != Steve } &raquo; Blog Archive &raquo; More on Linq to SQL

Pingback from  { null != Steve }  &raquo; Blog Archive   &raquo; More on Linq to SQL

# re: LINQ to SQL Debug Visualizer

Hi Scott,

I'm very impressed by LINQ, however one thing bothers me:

Is it possible that LINQ to SQL would generate it's entity classes (e.g. Product for Products table) in separate files?

Or even better - in separate project?

That's how it is e.g. in NHibernate, and it makes sharing those classes across layers in multi-layered application a lot easier. It's also easier to use it with distributed application, web services etc.

LINQ to SQL is totally totally better than typed datasets, and I'm very happy that MS chose this way. But until all generated classes will be stored simply in one file - it still won't be fully "enterprise" solution :(

Your reply will be appreciated.

# re: LINQ to SQL Debug Visualizer

I am having difficulty connecting to a remote SQL Server.  I have 2 copies of a database, one local and one remote.  Using the wizard for a Dataset, I tried in both cases to create a new Stored PRocedure.  IN the local case, all went fine, (as it has for years with 2005).  However, when I try to do the same on the remote, it fails on the last step with the error msg, "THe specific schema for "woofwoof" either does not exist, or you do not have permission to use it."  ("woofwoof" is the username for the database).  It seems like a permission problem.  I am running it in Vista Business OS. I have an capture of the error, if that helps.  

Otherwise, this looks like a great product!

# re: LINQ to SQL Debug Visualizer

Hi scott. i found a bug in the linq to sql. if the table name has any dot like 'Movie.Base.Studio' the linq to sql will generate the following code: [dbo].[[Movie].[Base].[Studio]]] instead of [dbo].[Movie.Base.Studio] and then return the following error: "Could not find server 'dbo' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers."

# re: LINQ to SQL Debug Visualizer

I could not find a method inside the linqdatasource that could return the results to a datatable or dataset. I found some sites saying about the GetDataTable() method in later linq releases. Do you know how is it called in the current release?

# re: LINQ to SQL Debug Visualizer

Hi Scott, I found some mistakes in 101 LINQ Samples (msdn2.microsoft.com/.../aa336746.aspx)

I think some of the code (such as 'List<Product>') did not show up.

# re: LINQ to SQL Debug Visualizer

Scott,

What are your thoughts on the whole issue of using SQL Server stored procedures or not?  I assume that LINQ appeals to developers who send SQL statements to SQL Server rather than calling stored procedures.

In your opinion, is it best to do as much in SQL stored procedures as possible, for better performance, scalability, etc, rather than using ASP to construct all the SQL necessary, and thus not needing stored procedures?

Thanks,

Hank

# LINQ to SQL デザイナビジュアライザ

LINQ to SQL デザイナビジュアライザ

# re: LINQ to SQL Debug Visualizer

Scott,

For those of us used to thinking in T-SQL, and who often take advantage of things like common table expressions and the new row and rank functions in 2005, would it be possible to provide a reverse visualizer/code generator that would generate C# LINQ from T-SQL? Any third parties working on this?

# re: LINQ to SQL Debug Visualizer

Hi Scott,

Thank you much for your continued support of the community. It's a great thing to have the MS folks blogging about the upcoming products.

My question is about mapping automation and the LINQ to SQL approach.  For the most part LINQ to SQL appears to only take the bottom up approach where you start from the database meta-data and work up to (or generate) the object model.  What about the other direction?  What if I have a robust domain model and I want to map to (or even generate) my data model.  Are there any plans to expand the designer to allow for more complete mapping functionality?  It would be nice to be able to drag my classes from "Solution Explorer" or "Class View" and have them show up in the dbml designer.

Thanks

# LINQ samples

LINQ samples

# MSDN events - more about LINQ, Silverlight and WCF

Did you attend one my events in August to September 2007 and want more information about the topics covered?

# MSDN Blog Postings &raquo; 2007 &raquo; August &raquo; 12

Pingback from  MSDN Blog Postings  &raquo; 2007 &raquo; August &raquo; 12

# re: LINQ to SQL Debug Visualizer

Hi Scott,

You write that:

"Developers can use LINQ with any data source, and built-in libraries are included with .NET 3.5 that enable LINQ support against Objects, XML, and Databases. "

Mike Taulty writes in his blog that:

"For me, the top 3 things to know about LINQ to Entities would be;

1 It will not ship with Visual Studio 2008 and .NET Framework V3.5. It comes "later". "

Am I missing out on something here or do You write different things about LINQ? If You write different things, whats the situation really like?

A link to Mikes blog: mtaulty.com/.../9558.aspx

Thanks

# Resources for MSDN Events - LINQ, WCF, Silverlight

Technorati tags: Resources , MSDN events , Portland MSDN Event , WCF , LINQ , Silverlight Thanks for

# re: LINQ to SQL Debug Visualizer

Thursday, August 02, 2007 11:06 AM by ScottGu

Hi Ken,

>>>>>>> Can you give us an update on the compatability with vb.net.

We've reprod the problem here internally, and someone is working on it now.  I'll let you know once there is an update or a potential fix.

Scott--can you provide an update on this. Thanks  Ken

# Linq Resources

I presented Linq at the .NET User Group in Phoenix last night and mentioned some great linq resources.

# MSDN Blog Postings &raquo; Linq Resources

Pingback from  MSDN Blog Postings  &raquo; Linq Resources

# re: LINQ to SQL Debug Visualizer

Can you provide an update regarding the fix for vb.net users.

Thanks

Ken

# LINQ - IQueryable, Mathematical Methods, and .Take (Top N) &laquo; Ramblings of the Sleepy&#8230;

Pingback from  LINQ - IQueryable, Mathematical Methods, and .Take (Top N) &laquo; Ramblings of the Sleepy&#8230;

# On the road with LINQ, WCF and Silverlight

…With a boulder on my shoulder feelin&#39; kinda older I tripped the merry-go-round With this very unpleasing

# DLINQ – Advanced topics – Debug mode – part 6

DLINQ is a great ORM engine with a lot of advantages. When I learned this tool I asked myself how I can

# On the road with LINQ, WCF and Silverlight

…With a boulder on my shoulder feelin' kinda older I tripped the merry-go-round With this very unpleasing

# Wie sehe ich welche SQL Befehle eine Linq to SQL Abfrage erzeugt?

Mit Linq ist es sehr einfach komplexe Abfragen auf eine Liste von Objekten anzuwenden. Um einmal hinter

# MSDN Blog Postings &raquo; Wie sehe ich welche SQL Befehle eine Linq to SQL Abfrage erzeugt?

Pingback from  MSDN Blog Postings  &raquo; Wie sehe ich welche SQL Befehle eine Linq to SQL Abfrage erzeugt?

# re: LINQ to SQL Debug Visualizer

Hi,

Does the visualizer not work with VB? Yeah I know I need to switch to C but this project is needed for a client in VB.

# 10 Things I Learned From the September MSDN Event in Atlanta at Die, AJAX!

Pingback from  10 Things I Learned From the September MSDN Event in Atlanta at Die, AJAX!

# It's AATT! Hot time in Miami last week! Looking for more tools to show...

The crowd loved it! The debut of “ It’s All About The Tools – Episode 1” took place in Miami at the Miami

# 101 LINQ Beispiele und weitere Links

Vor einer Weile hatte ich hier einen Beitrag zu den LINQ to SQL Tutorials von Scott Guthrie (1) veröffentlicht.

# Scott Guthrie Discusses how to debug LINQ

Scott Guthrie Discusses how to debug LINQ

# Linq to Sql Query Visualizer

Linq to Sql Query Visualizer

# Visualizer For LINQ Debuging

Scott Guthrie wrote a very nice visualizer for LINQ to SQL for easier debugging. Take a look on it and

# [.net][LINQ] LINQ to SQL のデバッグに。LINQ to SQL Debug Visualizer

Sorry,this entry is written only Japanese. weblogs.asp.net/.../linq-to-sql-debug-visualizer.aspx より。 Visual Studio で LINQ to SQL をデバッグすると のように変数の値をパラパラと展開して表示してくれます。これだけでも十分かも

# VS 2008 对 LINQ to SQL 辅助工具

当你在项目中使用LINQ to SQL的时候, 有一个事情是必须要非常注意的, 那就是要关心一下LINQ to SQL帮你生成的SQL语句, 尤其在你还不是非常熟悉LINQ to SQL的语法, API的时候, 这点是非常重要的。

# LINQ to SQL可视化调试工具

本来说是在VisualStudio2008Beta2中集成LINQto

# sachabarber.net &raquo; Nice LINQ Debugger Visualizers

Pingback from  sachabarber.net  &raquo; Nice LINQ Debugger Visualizers

# LINQ to SQL Visualizer isn't in the transaction it is visualizing

LINQ to SQL Visualizer isn't in the transaction it is visualizing

# Linq to SQL Debug Visualizer

On debug mode it is nice to see the generated sql query, but what about if we can execute the query against

# HowTo: LINQ to SQL debuggen | Code-Inside Blog

Pingback from  HowTo: LINQ to SQL debuggen | Code-Inside Blog

# HowTo: LINQ to SQL debugging | Code-Inside Blog International

Pingback from  HowTo: LINQ to SQL debugging | Code-Inside Blog International

# Un debug visualizer per LINQ-to-SQL

Un debug visualizer per LINQ-to-SQL

# LINQ to SQL Debug Visualizer

LINQ to SQL Debug Visualizer

# Episode 10: LINQ | Herding Code

Pingback from  Episode 10: LINQ | Herding Code

# LINQ to SQL Debug Visualizer

LINQ to SQL Debug Visualizer

# 10 Tips to Improve your LINQ to SQL Application Performance

Heythere,backagain.InmyfirstpostaboutLINQItriedtoprovideabrief(okay,bitdetailed)in...

# Logging your Sql with LINQ Update Commands. Simple Logging to your Visual Studio 2008 Debugger Output Console | PeterKellner.net

Pingback from  Logging your Sql with LINQ Update Commands.  Simple Logging to your Visual Studio 2008 Debugger Output Console | PeterKellner.net

# Visual Studio 2008 LINQ to SQL Visualizer

Visual Studio 2008 LINQ to SQL Visualizer

# [Debug] Linq To Sql - .Net and MOSS News

Pingback from  [Debug] Linq To Sql - .Net and MOSS News

# LINQ Resources &laquo; Vakul Kumar More

Pingback from  LINQ Resources &laquo; Vakul Kumar More

# 【LINQ-SQL Debug】 一个实用工具

LINQ-SQL开发时比较实用的一个tool，LINQ-SQL Debug Visualizer。它可以帮助我们调试LINQ query所生成的扩展方法，以及转换的SQL脚本等，比Visual Studio自带的Debug工具要强大一些，能反馈出更多的信息。

# 在Linq to Sql中管理并发更新时的冲突（1）：预备知识

无论与目前的ORM框架相比有没有优势，Linq to Sql在语言和平台的级别上为我们提供了一种新的操作对象和数据的方式，在一定程度上为我们解决了Object != Data的问题。在实际应用中，对于数据库的操作往往有着天生的并发性，因此在更新数据时可能会产生冲突。有些时候，如果没有合理的解决冲突问题，轻则让用户摸不着头脑，重则让系统数据处于一种不一致的状态。Linq to Sql自然考虑到了这一点，本系列讨论的内容，就是在使用Linq to Sql时，如何管理并发更新时产生的冲突。 本文为这个系列的第一篇

# L???y d??? li???u d??ng Stored Procedure (LINQ to SQL ph???n 6) &laquo; ????o H???i Nam

Pingback from  L???y d??? li???u d??ng Stored Procedure (LINQ to SQL ph???n 6) &laquo; ????o H???i Nam

# L???y d??? li???u d??ng Stored Procedure (LINQ to SQL ph???n 6) &laquo; ????o H???i Nam

Pingback from  L???y d??? li???u d??ng Stored Procedure (LINQ to SQL ph???n 6) &laquo; ????o H???i Nam

# LINQ to SQL Debug Visualizer &laquo; WebJagger&#8217;s Blog

Pingback from  LINQ to SQL Debug Visualizer &laquo; WebJagger&#8217;s Blog

# LINQ to SQL: Debugger Visualizer Error: No quotes for string values

Recently when I was using LINQ to SQL (which I happen to love so much) and using the LINQ to SQL debug

# ScottGu&#8217;s Linq to SQL Debug Visualizer &laquo; Blog Bustin&#039; .NET Beats

Pingback from  ScottGu&#8217;s Linq to SQL Debug Visualizer &laquo; Blog Bustin&#039; .NET Beats

# S??? d???ng LINQ to SQL Part 6 | IT-C?? ????n

Pingback from  S??? d???ng LINQ to SQL Part 6 | IT-C?? ????n

# Designing A Data Access Layer in LINQ to SQL

这篇帖子里讲了事务处理方面的东西，开阔了我的思路。但是对于具体的层次架构的东西（例如如何具体的编写DAL代码）没有陈述。而在代码中，BPL（业务层）和DAL的分工并不明确，BPL只是简单的将DAL...

# Praktische Tools f

Praktische Tools f

# Praktische Tools für das Monitoring von LINQ to SQL Abfragen

Oft ist es schwierig das Ergebnis von LINQ to SQL-Abfragen zu debuggen oder zu monitoren. Hierbei helfen