SQL Server [rss]

Mocking LINQ to SQL

Matt Warren has an "interesting" post on how you could hack your way to a mocked implementation of LINQ to SQL - if I had a pound for every time someone's asked me how to do this then I'd have at least 3 pounds :-) Seriously though, there is interest Read More

Filed Under: ,

LINQ to SQL and SqlConnection ( "when you're wrong, you're wrong" :-) )

I was talking to Ian and another chap at the UK Launch yesterday about LINQ to SQL and my use of the DataContext in some demo code where I always tend to write something like; using (DataContext ctx = new DataContext()) { } and whether Read More

Filed Under: ,

LINQ to SQL, Stored Procs, Output Params, Readers Reading

I had a discussion at DevWeek about when SqlDataReader.Read() gets called for resultsets coming back from stored procedures accessed with LINQ to SQL. I've got this stored proc;create procedure dbo.GetCustomersByCountry @country nvarchar(max) as Read More

Filed Under: , ,

ADO.NET Entity Framework - QueryViews, Inline Functions in SSDL

I have a mail from Tim on the EF team that I've had for a little while. I'd asked a question about mapping and he'd given me an answer saying something like "Oh, you could always do X, Y, Z" and I'd left this mail in my inbox for a while because I've Read More

SQLBits - Birmingham, 1st March

Just a quick plug :-) I'm speaking at the "SQLBits" conference in Birmingham on the 1st March. The agenda is up here. The agenda is built by voting from prospective attendees and I found it interesting in that I submitted a few sessions that looked Read More

Filed Under: ,
More Posts Next page »