Monday, October 22, 2007

LINQ to SQL will inject Stored Procedure ?!

I have attended a day course that was created by Michele Leroux Bustamante.

One of the thing that was communicated in the day course was that LINQ to SQL will actually inject stored procedure for each query you are creating (it will also handle the caching of them and etc).

From my point of view this means that LINQ to SQL will never be used directly inside an ASP.NET or other application because that would mean that the process identity will have to have enough rights to inject the stored procedure and who will approve that.

I didn't get any information that it would be configurable behavior.

The only reason that I can think of my self that can cause such behavior is to MAYBE enable the stored procedure to be altered by DBA and that makes some sense (this will reduce the usual syntax from the DBA saying "I will let you write C# and you will let me write SQL")

In the link provide above to LINQ to SQL you can find a text that says "LINQ to SQL is designed to be non-intrusive to your application" and I find it a little funny because what can be more intrusive than altering the DB :)

Currently I didn't find any indication of this behavior but you can be sure that I will update my article in the near future.

Saturday, October 13, 2007

Microsoft ASP.NET Connections

I am going to participate in the Microsoft ASP.NET Connections conference at LAS VEGAS in November (schedule information)
I hope that we will have couple of sessions about the new MVC frameowork.
See you their, I will update on a regular basis.

ASP.NET MVC Framework public release date

I sent an email to Scott asking to participate in testing of this framework and Scott replied with "Not yet..." answer but he also said that the first public (CTP) should be released in 6 - 8 weeks.

So I guess this is good enough, I just hope that they will provide all the documentation before the actuall release, so that we can prepare for it.