Just a quick plug – tomorrow evening I’m doing a session on ADO.NET Data Services (“Astoria”) at the SQL Server User’s Group at Microsoft, Reading. See here for details; http://sqlserverfaq.com/events/167/Sessions-on-Understanding-ADONET-Data-Services-Windows-7-features-indepth-and-the-usual-SQL-Nuggets...
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.
Following on from that previous post about the WPF DataGrid I thought it might be interesting to try and move towards more of a master/details view with a separate grid displaying the orders for each customer. I modified the UI a little bit; < Window x:Class ="BlogPost.Window1" xmlns ="http://schemas...
Mike was chatting to me about how you'd take something like this ( against LINQ to SQL and the Northwind database ); using (NorthwindDataContext ctx = new NorthwindDataContext() { Log = Console.Out }) { string [] values = { "A" , "B" , "C" }; var query = from c in ctx.Customers select c; foreach ( string...
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...
Short video on working with the new varbinary (max) filestream data type in SQL Server 2008. Hover near the bottom of the player for controls. Double-Click the player for full-screen. I don't have a downloadable version at the time of writing so will update the post later when I have one. The post...
Short video on working with the new varbinary (max) filestream data type in SQL Server 2008. Hover near the bottom of the player for controls. Double-Click the player for full-screen. I don't have a downloadable version at the time of writing so will update the post later when I have one. This post...
I saw a question recently about how to asynchronously execute a LINQ to SQL query. Unless you want to go down the "fake async" route of pushing a query out onto the ThreadPool, you can (AFAIK) do real async work by using the GetCommand() method of the DataContext and then doing the work yourself. So...
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...
Ok, so this whole post probably falls into the category of "nasty hack" but it was something that I was playing with so I thought I'd share. I wrote a little bit here previously about working with LINQ to SQL in a disconnected sense and wrote about how, if you wanted to manage concurrency in a reasonable...