A big thanks to all the people who came along to my session at SQLBits today on ADO.NET Data Services and also to the organisers and community around SQLBits that made the event happen in the first place. I was there for most of the afternoon and it seemed like a fantastic event to me in a cool venue...
Tantalising post from the Astoria team.
Someone asked me if I had a simple sample of how to read/write documents into a database table using FILESTREAM in SQL Server 2008. I set about it. Firstly, I had to find out how to switch FILESTREAM on in the RTM of SQL Server. At times like this you need Bob Beauchemin to tell you how it's done and...
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...
Julie's got a great post about when stored procedures execute when using LINQ to Entities . It made me think about LINQ to SQL where if I've got something like; using (NorthwindDataContext ctx = new NorthwindDataContext()) { var query = ctx.GetCustomersByCountry( "UK" ); // SQL Happens Here! foreach...
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...
One of the things that I didn't mention (because I didn't know and I'm still not 100% sure :-)) in this post was what happens with associations when you're using ADO.NET Data Services and non-Entity Framework providers. If you've got an Entity Framework data source exposing Customers and Orders then...
If you're seeing this error when using the webdatagen.exe tool with the Data Services CTP; error 7001: Schema specified is not valid. Errors: (0,0) : error 0005: The 'Namespace' attribute is invalid - The value '' is invalid according to its datatype ' http://schemas.microsoft.com/ado/2006/04/edm:TName...
Entity Framework Beta 3 is available along with a new Entity Designer (CTP 2) is out as well. These are for Visual Studio 2008 RTM and .NET Framework V3.5 RTM. Find blog posts up here; ADO.NET Entity Framework Beta 3 Released! Entity Designer CTP2 with the full details but I like the sound of; Simpler...
Hmmmmmmm. If I had a pound for every time someone has asked me in the past "What's the best way to pass an array of values into a SQL Server stored procedure" then I'd have at least 4 pounds :-) I've seen people do it with strings. I've seen people do it with XML (both before and after SQL Server actually...