-
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...
-
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...
-
I'm doing a talk down at ACCU this evening on VS 2008 and, specifically, as it's a short talk focusing on what I think is the biggest single thing in VS 2008 which is what changes around the languages and LINQ. The slides for the talk are here in PPTX , PPT and PDF formats.
-
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...
-
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 in doing this kind of thing and it's a good starting...
-
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.
-
Thanks to the people who came along to my talk on Entity Framework at VBUG in Bristol yesterday. I promised that I'd make the slides available and they can be found here for download in PPTX format and PDF format . This was more or less the same talk as I delivered at Southampton the week before so these...
-
<rant strength="veryMild"> A bit of a personal bugbear. I've met a lot of folks who say things like "How do you compare LINQ and traditional data access?" or something along those lines. Please. You've got to stop calling it "LINQ" :-) LINQ is not necessarily anything to do with relational database...
-
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 I actually needed to do that dispose or not? Now...I was pretty confident...
-
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...
-
A new version of the LINQ to XSD preview that works with Visual Studio 2008. Get the details from here . If you're not so sure on what LINQ to XSD is all about it's essentially for the people who see some LINQ to XML code and say; "But how come the LINQ to XML code has all those ugly strings and casts...
-
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...
-
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 something like; "Entity Framework Tour" "LINQ to SQL...