I came across a bit of a glitch in using timestamps for checking concurrency violations in LINQ to SQL and thought I'd share. Say I've got a table like; create table Person ( id int identity primary key , firstName nvarchar(30), lastName nvarchar(30), timestamp ) so, we have a simple table that has a...
Thanks a lot to the people who came along to my Entity Framework talk at the Oracle and .NET Special Interest Group in London today. As promised, I've uploaded the slides in PPTX and PDF format if you need them for anything.
I did a talk yesterday down at the UK Launch of Visual Studio 2008, SQL Server 2008 and Windows Server 2008 about Language Integrated Query as it stands in VS 2008 and .NET Framework V3.5. Firstly, thanks to everyone who came along to the talk - much appreciated. Also a massive thanks to the guys who...
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 set nocount on select * from dbo.customers where country...
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 been distracted and also because I didn't really understand...