-
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...
-
Just a link from me at the moment but there’s a preview of the “Astoria Offline” work that was shown at the PDC now available from here I’m hoping to get time to download it and take a look at it in the near future.
-
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 produced a new set of short videos around ADO.NET Data Services and dropped them on to Channel 9. You can find them here; http://channel9.msdn.com/tags/UK and that list will grow as time goes in ( specifically, it'll grow if I can get the publishing system to publish my next 4 videos for me as it's...
-
This is similar but not at all identical to this post about LINQ to SQL because it's using a different framework and that has different capabilities. Someone mailed and asked how we can detect concurrency problems with Entity Framework in order to ensure that when we submit changes to the DB we first;...
-
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...
-
Following on from this last post , if I start to edit the data in the grid and change some value then the property value will change in the underlying class but nothing else will happen. That is, the NorthwindEntities class which is managing my data for me client-side ( which is derived from DataServiceContext...
-
Someone mailed me to ask whether I had a video on how to put together Silverlight and ADO.NET Data Services. I don't at the time of writing and I've also got a cold right now ( thank you, Microsoft Manchester office :-) ) so I thought I'd write something rather than record it. Let's run through a step...
-
Someone asked me today how you'd go about ensuring that timestamp columns in your database tables show up in your Entity Framework EDMX file with a Concurrency=Fixed attribute on them. That is - it's very likely that the timestamps are there on the table to enforce concurrency so why not default their...
-
I made an attempt at implementing IUpdatable on the current (i.e. VS 2008 Sp1 B1) bits of ADO.NET Data Services. I struggled a little bit with this. When you produce a data service you provide a class which is derived from; DataService<T> and T might be your own custom type or it's more likely...
-
Something that I came across today - if you're trying to surface a LINQ to SQL data source via the latest build of ADO.NET Data Services and you're running datasvcutil.exe on the metadata of the service then you might find yourself with a whole bunch of errors. Here's a sample of what I was getting this...
-
Once we've got a request authenticated the next thing we might want to consider is authorising those requests as they make access to data. In researching this post I found that I'd actually written about this before but hadn't been quite as complete as I'd like to be ( and, to be honest, with my 5-minute...
-
Just like for batching, there's a great explanation of how concurrency looks in ADO.NET Data Services up here so this is just a basic example. If I take the "Hello World" style service that I built back here then it does nothing about concurrency checking because, by default, when you build an entity...
-
I did a talk on Data Services at DevDays, Amsterdam last week and so I had to take a rather speedy look at batching support as that had been added to the VS 2008 Sp1 bits since the previous preview. Batching is explained up here but here's just a little example of using it. If we take "hello world" style...