Geeks With Blogs

News

This blog has moved to ericnelson.wordpress.com

 Subscribe in a reader

Add to Google Reader or Homepage


Links
View my teams slideshare
These postings are provided "AS IS" with no warranties, and confer no rights.



IUpdateable has moved to ericnelson.wordpress.com Please visit http://ericnelson.wordpress.com Entity Framework
Q&A: Will my favourite ORM Foo work with SQL Azure?
short answer: Quite probably, as SQL Azure is very similar to SQL Server longer answer: Object Relational Mappers (ORMs) that work with SQL Server are likely but not guaranteed to work with SQL Azure. The differences between the RDBMS versions are small – but may cause problems, for example in tools used to create the mapping between objects and tables or in generated SQL from the ORM which expects “certain things” :-) More specifically: ADO.NET Entity Framework / LINQ to Entities can be used with ......

Posted On Monday, June 7, 2010 4:05 PM

Great User Group if based near Gloucester + Links from Entity Framework 4.0 session
I had a really fun evening doing “my final” EF 4.0 session last night (26th May 2010) at GL.NET based out of Gloucester (although secretly I made it into a IronRuby and Windows Azure session). They are a great crowd and Jimmy makes for a fantastic host + it is a very nice venue (Symantec offices in Gloucester, lots of parking, good room etc) + free pizza + free SWAG + trip to pub afterwards (the topics were very varied!). What more could you ask for? The next session is June 16th and will be on multi-tenanted ......

Posted On Thursday, May 27, 2010 10:46 AM

Links from UK TechDays 2010 sessions on Entity Framework, Parallel Programming and Azure
[I will do some longer posts around my sessions when I get back from holiday next week] Big thanks to all those who attended my 3 sessions at TechDays this week (April 13th and 14th, 2010). I really enjoyed both days and watched some great session – my personal fave being the Silverlight/Expression session by my friend and colleague Mike Taulty. The following links should help get you up and running on each of the technologies. Entity Framework 4 Entity Framework 4 Resources http://bit.ly/ef4resources ......

Posted On Wednesday, April 14, 2010 11:41 PM

GuestPost: Unit Testing Entity Framework (v1) Dependent Code using TypeMock Isolator
Time for another guest post (check out others in the series), this time bringing together the world of mocking with the world of Entity Framework. A big thanks to Moses for agreeing to do this. Unit Testing Entity Framework Dependent Code using TypeMock Isolator by Muhammad Mosa Introduction Unit testing data access code in my opinion is a challenging thing. Let us consider unit tests and integration tests. In integration tests you are allowed to have environmental dependencies such as a physical ......

Posted On Wednesday, March 24, 2010 9:07 PM

Poll on Entity Framework 4 – one year on
12 months back (today is March 15th 2010) on the 16th of March 2009 I created a poll on Entity Framework v1 – the marmite of ORMs? A quick poll…. Entity Framework v1 was getting a mixed reception at the time – I met developers who genuinely hated it and I met developers who were loving the productivity improvements they were seeing. There were definitely issues with v1, too many IMHO. Which is why the product team placed a huge effort on listening to the community to drive the feature set for v2 ......

Posted On Monday, March 15, 2010 5:03 PM

Slides and links from Entity Framework 4 session
On Monday 15th Feb 2010 I gave an overview session on Entity Framework 4 for the Developers Group. A big thanks to those who attended and asked great questions. My slide deck from the session: Entity Framework 4 In Microsoft Visual Studio 2010 View more presentations from ericnelson. A related set of screenshots from the demos I gave (or at least, a similar set of demos I did in Oct 2009): Dev305 Entity Framework 4 Emergency Slides View more presentations from ericnelson. Related Links: 101 EF4 Resources ......

Posted On Tuesday, February 16, 2010 1:21 PM

Vote for future Entity Framework and Data Services Features
Blatant repost alert from the ADO.NET team blog! But important IMHO. The Microsoft data team are looking for help to prioritize future work. Is there a feature that you’ve always wanted to have? Or a bug in VS2010 RC? Then provide feedback directly to the teams at the new Connect site. Including: ADO.NET Entity Framework WCF Data Services Thanks all ......

Posted On Wednesday, February 10, 2010 10:50 PM

Entity Framework 4.0 Resources gets a December 2009 Update
I have just completed a first round of updates to my popular blog post from September Entity Framework 4.0 Resources – documentation links, best blog posts and more Pop a comment here or better still in the main post if I missed something cool! (Which no doubt I have) The following were added: Overview blog posts/articles What’s New in Entity Framework 4, Part 2: Modeling Changes (Nov/Dec 2009) Renovations to .NET 4.0's Entity Framework (Nov 2009) Entity Sequel (Dec 2009) 5 Steps to having a great ......

Posted On Tuesday, December 15, 2009 9:20 PM

MSDN Flash Podcast 014 – Entity Framework and ADO.NET Data Services at TechEd Europe
This podcast was recorded at TechEd Europe in November 2009. I get a chance to sit down with Mike Flasko, Program Manager in the Data Services team. We had both presented on Entity Framework during the conference which is where we started the discussion before we moved on to talk about Data Servies and some of the announcements around Data Services, RIA and WCF which would be happening the following week at PDC. Definitely worth a listen (IMHO). Listen/Subscribe: Download/Play MSDN Flash Show 014 ......

Posted On Thursday, December 10, 2009 11:54 AM

5 Steps to having a great time with Entity Framework 4 Beta 2
Step 1 Install Visual Studio 2010 Beta 2 http://bit.ly/vs2010b2 TIP: This works great inside Windows Virtual PC (10MB download) on Windows 7 if you want to avoid using it on your main machine Step 2 Install ADO.NET Entity Framework Feature Community Technology Preview 2 http://bit.ly/ef4ctp2 TIP: The CTPs give you additional functionality such as self tracking entities – which you need for N-Tier work Step 3 Install the beta of LINQPad for VS2010 Beta 2 http://linqpad.net/Beta.aspx TIP: I recommend ......

Posted On Friday, December 4, 2009 9:32 AM

Slides and links for Entity Framework 4 session for .NET Developer Network UG
Last night (3rd Dec 2009) I was lucky enough to be speaking at my local (and most excellent) user group http://www.dotnetdevnet.com/. There were plenty of mince pies and lots and lots of swag to give away – plus great questions and chats in the breaks. Thoroughly enjoyed it. Slides: Entity Framework 4 In Microsoft Visual Studio 2010 - ericnel View more presentations from ukdpe. Links from the session: Install VS2010 Beta 2 http://bit.ly/vs2010b2 LINQPAD beta for Visual Studio 2010 Beta 2 http://linqpad.net/Beta.aspx ......

Posted On Friday, December 4, 2009 9:04 AM

Entity Framework Interview – yep, this is what I look like!
In March 2009 I presented on Entity Framework V1 and a little V2 at DevWeek 2009. MikeT caught me on camera while I was there. I have (rather embarrassingly) only just got round to publishing the video. Ultimately I run out of excuses and was only left with … I’m shy :-) I presented an updated version of the deck earlier this Month (May) which you can view here along with additional links ......

Posted On Wednesday, May 20, 2009 4:16 PM

Getting Started with Entity Framework 4 – Lazy Loading
[This is the fifth in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009).] Entity Framework v1 did not support a commonly implemented ORM feature called Lazy Loading. Entity Framework 4 adds that feature. In Beta 1 it was known (confusingly IMHO) as Deferred Loading. In Beta 2 it is (thankfully IMHO) known as Lazy Loading. You run up against the absence of Lazy Loading in v1 when you ......

Posted On Thursday, November 26, 2009 10:23 AM

Entity Framework 4 at TechEd Europe – standing room only
On Monday at 9am (9th Nov 2009) I presented a session on Entity Framework 4 to several hundred attendees at TechEd in Berlin (DEV305). I have presented EF to developers many times before but this was the first time I had shown the new EF 4 in any detail. I was really interested in the questions and feedback after the session. The tone was much more positive. Developers recognise that we are addressing their concerns with v1 and that v4 includes many very welcome improvements. They just want to get ......

Posted On Wednesday, November 11, 2009 10:07 PM

QandA: Is the ADO.NET Entity Data Model designer fixed in .NET 4?
[I haven’t done QandAs for a long while – very remiss of me.] Anyway, I have been asked this one so many times lately that I felt a more public answer was needed. The short answer is: Mostly. Certainly it is good enough to get work done. The longer answer is below… History In the first version of Entity Framework (which came with .NET Framework 3.5 SP1), the Entity Framework Designer was… bad. I mean very bad. I mean dumbly bad. We had a decent enough runtime but the design surface just wasn’t up ......

Posted On Tuesday, November 24, 2009 1:25 PM

Getting Started with Entity Framework 4 – Complex Types and Entities
[This is the fourth in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009).] Complex Types make it easier to work with objects, allowing the grouping of related properties in Entities and the reuse of these groupings across Entities. The first release of Entity Framework included Complex Type support but did not expose this capability through the Entity Data Model Designer. The good ......

Posted On Tuesday, November 24, 2009 12:46 PM

SQL Azure and Entity Framework sessions from PDC 2009
Two areas I am looking at right now are SQL Azure and Entity Framework 4. PDC had plenty of content on both these areas. Just need to find the time to watch some of it! I have added direct links to the standard definition WMV and the PPTs to download (which is what I am doing right now). SQL Azure SQL Azure Database: Present and Future Windows Media Video PPT Using the Microsoft Sync Framework to Connect Apps to the Cloud Windows Media Video PPT The Future of Database Development with SQL Azure Windows ......

Posted On Monday, November 23, 2009 5:03 PM

T4 Templates and the answer to life, the universe and everything
[This is the third in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009).] Entity Framework 4 relies significantly on the Text Template Transformation Toolkit (T4) to generate code from the EDM. I thought it would be useful to show a really simple example of T4 in action which is nothing to do with Entity Framework. In a Visual Studio 2008/2010 solution, add a new item of type Text ......

Posted On Friday, November 20, 2009 9:22 AM

Tangible T4 Editor – a life saver
I have been working with T4 (Text Template Transformation Toolkit) lately thanks to the Entity Framework team moving their code generation model over to T4 in Visual Studio 2010. However by default Visual Studio 2008 and 2010 do not include syntax highlighting or intellisense support for T4 files, which makes it rather difficult to work with them (very difficult at times!). Thankfully there are partners who address this. The one I am using with Beta 2 of Visual Studio 2010 is the Tangible T4 editor. ......

Posted On Friday, November 20, 2009 9:18 AM

Getting Started with Entity Framework 4 - Templated Code Generation
[This is the second in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009).] Code generation from the Entity Data Model (EDM) has changed significantly in version 4 of the Entity Framework. The product does retain a backwardly compatible model of code generation but also now includes T4 templates for code generation. This is a fantastic addition to the Entity Framework as many developers ......

Posted On Thursday, November 19, 2009 1:47 PM

Getting Started with Entity Framework 4 – Simple Model First Example
[This is the first in a series of posts on getting started with the new features in Entity Framework 4 based on the demos I did in my session at TechEd Europe in Berlin last week (Nov 2009). ] When adding an Entity Data Model to a project you are given the option to: Generate the Model from an existing database (SQL Server, Oracle etc) or Start with an Empty Model and create your conceptual model (sometimes referred to as Application Model or Domain Model) first – adding new Entities and Associations ......

Posted On Tuesday, November 17, 2009 10:30 PM

Summary of the Entity Framework 4 changes introduced with Beta 2 and CTP 2
I thought it would be useful (at least to me!) to summarise the new stuff in Entity Framework 4 given it actually comes in 2 parts. The list is a simplified and categorised version of this and this. General Foreign Keys now added: EF 4 now includes a new type of associations (Foreign Key Associations) that allow you to have Foreign Key properties on your entities. They are the default although the EF v1 Independent Associations remain. Lazy Loading on by Default in new Models: Also name change from ......

Posted On Friday, November 6, 2009 4:37 PM

The relationship between Entity Framework 4 betas and ctps explained
There seems to be enough confusion about the betas and ctps of Entity Framework 4 to warrant a brief post. Hopefully this should clear things up nicely. Put simply: Most of Entity Framework 4 (EF4) will ship with .NET Framework 4 and Visual Studio 2010 (.NET4/VS2010), however not all of it will. Most of EF4 is therefore in the beta releases of .NET4/VS2010, however not all of it is. The missing bits of EF4 appear in EF4 Feature CTP releases “soon after” the release of a beta. Right now (Nov 6th 2009), ......

Posted On Friday, November 6, 2009 4:13 PM

The Plan B is all my DEV305 Entity Framework 4 demos as slideware
Next week I will be presenting Entity Framework 4 at TechEd Europe. At least that is what I hope to do. However my Lenovo T61P seems to have some other plans. A year back the screen packed in. The nice IBM man replaced it. All was well. Last week the screen packed in again. The nice IBM man replaced it. All was well … with the screen. However since then I am getting blue screens (whenever I really don’t want them) and drive errors and the odd bit of corruption of files. I need to flatten – but now ......

Posted On Friday, November 6, 2009 3:29 PM

Entity Framework 4 Session DEV305 at TechEd Europe 2009 – what to expect
Next Monday (9th Nov 2009) at 9am I will be delivering an overview of the new stuff in Entity Framework 4 at TechEd Europe. The session is DEV305 and the description reads: ADO.NET Entity Framework in Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 (catchy?) This presentation offers an in-depth discussion demonstrating the new capabilities of the Entity Framework that will ship with Visual Studio 2010. The second release of the Entity Framework focuses on addressing two primary customer ......

Posted On Friday, November 6, 2009 3:23 PM

Midnight and the Azure and Entity Framework decks are now final and available for download
You might have been following this series of posts on my preparation for Software Architect 2009. Well, this evening while sitting in a small hotel room in London (with no window and a dodgy tv) I completed both presentations and made them available for download on Slideshare. You can find them both here. P.S. I still need to add links to that page ......

Posted On Wednesday, September 30, 2009 12:20 AM

Countdown to Software Architect 2009 – the last day retrospective
This is one of a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. The plan vs actual for day five (The last day): Play, play, play with the technology. PART DONE Produce outline skeleton demo sequence for both sessions PART DONE Produce a backup VM “just in case” :) DONE Run through both presentations for rough timing (mainly to figure out talk to demo ratio) PART DONE Look into this annoying bug which appeared to have started after I installed Silverlight ......

Posted On Monday, September 28, 2009 2:51 PM

ADO.NET Entity Framework and large databases ... fine with 400 tables/views
I keep talking about Entity Framework and I keep getting asked about large databases. I have a stock answer based on work by an early adopter and some other stuff – but I kept meaning to try this out myself. I was about to give it a whirl when I decided to do a quick search (as TBH I am pressed for time today) and came back with this post from Julie – which pretty much matches the limited testing I was about to try. Julie tested the design tool with 400 tables and views Model generation < 1 min ......

Posted On Wednesday, January 21, 2009 2:29 PM

Countdown to Software Architect 2009 – Day four and the slides are done
This is one of a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. The plan vs actual for day four (Thursday): Produce final drafts of each deck and post them so delegates can check out what I’m covering. DONE (link below) Play, play, play with the technology. DONE (a little) Read, read, read DONE And… produce outline skeleton demo sequence DONE (a little) The good bit: The best bit was getting the drafts of both decks “done” – done in the sense that I ......

Posted On Friday, September 25, 2009 9:52 AM

Countdown to Software Architect 2009 – Day three was Entity Framework 4 day. I love it!
This is one of a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. The plan for day three: Nearly got it all done. However I ended up spending more time on EF4 than I had planned as … there is a lot of it! Gather up good posts and samples for EF 4 (will likely blog this out) DONE Play with EF 4 as much as my day allows DONE Revisit EF 4 deck post play DONE And a late night re-read of the three Azure storage documents from way back (will add links in the ......

Posted On Thursday, September 24, 2009 9:09 AM

Entity Framework 4.0 Resources – documentation links, best blog posts and more
This is one of a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. [Initual release 22nd Sept 2009] [Updated 23rd Sept, with links from Julie Lerman] [Updated 2nd Oct, with slidedeck section] [Large Update 15th Dec – including PDC09 content, my new posts and plenty of stuff from Julie L, Tony and others] This is my attempt to pull together all (ok – most) of the improvements in Entity Framework 4.0 and aggregate useful resources against each. It is very ......

Posted On Wednesday, September 23, 2009 3:16 PM

Countdown to Software Architect 2009 – Day one summary and the eureka moment
This is the second in a series of posts on my preparations for sessions on Azure and ORMs at Software Architect 2009. In case you don’t want to skim through the whole post, the main things I learnt in day one are: 1. Never forget that install errors can be caused by something as simple as a corrupt file! (My “battle” outlined below) 2. Virtual PC RC for Windows 7 isn’t perfect. It doesn’t like working with a VM created on an older version. (Details below) 3. There are some nice storage explorer tools ......

Posted On Tuesday, September 22, 2009 11:50 AM

Update on the Entity Framework V2 in .NET 4.0 and Visual Studio 2010
I have started talking to developers about what they can expect in Entity Framework V2 such as in my session at DevWeek 2009 (Check out the slides and links). Folks have liked what they have heard and are keen to get more detail. The good news is the development team have been busy posting updated information this week (May 11th and 12th 2009) about what we can expect to see in .NET 4.0. Update on the Entity Framework in .NET 4 and Visual Studio 2010 “Since we shipped the .NET Framework 3.5 SP1 and ......

Posted On Wednesday, May 13, 2009 5:58 PM

Slides and links from NxtGenUG session on Entity Framework V1 and V2
Had a great time on Tuesday (5th May 2009) at NxtGenUG in Oxford. A very friendly crowd, a fun user group and great to watch the banter between Alex and Barry first hand, rather than over twitter :-) I also won a rubber duck – which justifies working in the evening in my book :-) Useful links: MSDN Flash eBook 13 of the “Best Technical Articles of 2008” (also http://bit.ly/flashebook1) MSDN Flash Podcast Pilot For feedback (also http://bit.ly/flashpod1) http://blogs.msdn.com/efdesign The Entity Framework ......

Posted On Thursday, May 7, 2009 7:44 AM

DataDirect add support for Entity Framework to Oracle
I’m very pleased to see that DataDirect have a beta of their Connect for ADO.NET Entity Framework provider for Oracle which now adds support for the ADO.NET Entity Framework. Still in Beta (1st may 2009) and available for download. Enjoy (and feedback what you find – tx) P.S. Other companies also provide this capability – but I know a lot of folks use DataDirect for Oracle work ......

Posted On Friday, May 1, 2009 9:43 AM

Entity Framework Books (with Amazon UK links)
Having been asked 5 times today for recommendations, I figure this post is long overdue: There are several books out there but IMHO these are the two you should purchase. Julia is focused entirely on Entity Framework (all 800+ pages!) and Roger takes a broader look at ADO.NET3.5 but does a great job on Entity Framework. Programming Entity Framework by Julia Lerman (Author) and Professional ADO.NET 3.5 with LINQ and the Entity Framework by Roger Jennings (Author) ......

Posted On Wednesday, March 25, 2009 4:57 PM

Entity Framework v1 and v2
Today I delivered a session introducing Entity Framework at www.devweek.com. I expanded the session to include a brief overview of the new stuff we should expect (but I don’t guarantee) will ship in .NET Framework 4.0 with Visual Studio 2010. First up, some useful links: Main ADO.NET Entity Framework site including “How To” videos Well written overview article My previous posts on Entity Framework Entity Framework v2 features http://blogs.msdn.com/efdes... ADO.NET team blog including plenty on the ......

Posted On Wednesday, March 25, 2009 4:40 PM

Fiddler and ADO.NET Data Services
It was my colleague MikeT who put me on to Fiddler a while back and it has proven to be really useful for my work with Data Services. By chance I just came across this example in which Shawn uses Fiddler to look at performance issues. At which point I decided Fiddler definitely needs a “shout out” :-) You will find MikeT using it in many of his ADO.NET Data Services screencasts over on Channel9. P.S. Nice work by Shawn to host a Silverlight sample ADO.NET Data Services over NorthWind using Entity ......

Posted On Wednesday, January 21, 2009 2:26 PM

Concept map of rough edges in ADO.NET 3.5 SP1
We have a rather impressive set of new technologies for working with data – LINQ, LINQ to SQL, LINQ to Entities, Data Services, ASP.NET Dynamic Data etc. What I am finding is… they don’t all get on with each other as well as you might have thought. My current battle is using ADO.NET Data Services with LINQ to SQL which is a) clearly something you might want to do and b) is something that isn’t going to work for you straight out of the box ......

Posted On Wednesday, January 21, 2009 2:22 PM

Speaking at DevWeek 2009 in London – hope to see you there
Next week (23rd March 2009) I am speaking at DevWeek 2009. DevWeek is a great conference which attracts top notch speakers (plus me – I feel such a fraud whenever I present there!). It is IMHO the best developer focused conference we have in the UK and I can’t wait to get there and soak in the great sessions + catch up with familiar faces + meet plenty of new ones. Be warned. There is a rumour that we are being given some new toys (Flip video cameras) to play with while we are there. However don’t ......

Posted On Thursday, March 19, 2009 4:46 PM

Q&A: Is there an Entity Framework provider for IBM DB2?
This one has come up a few times lately, hence I felt it would be worth surfacing here. Short answer is - “yes”. Longer answer is described in detail over on IBMs site along with a detailed description of the limitations. Note that this also supports IBM Informix Dynamic Server and IBM UniVerse and UniData (U2) Data Servers ......

Posted On Tuesday, March 17, 2009 3:58 PM

LINQ to SQL and LINQ to Entities (Entity Framework) performance comparison
[Don’t forget to vote on what your experience has been with the Entity Framework in my marmite poll :-)] I get asked a lot about performance of our two ORMs against each other and against standard ADO.NET. The short answer is “Normally it is good enough. When it is not good enough, you need to do something to make it good enough” My slightly longer answer is “In general LINQ to SQL performs better on query, LINQ to Entities performs better on updates” But – people like numbers, tables and comparison ......

Posted On Tuesday, March 17, 2009 11:21 AM

Entity Framework v1 – the marmite of ORMs? A quick poll…
In the UK we have something called marmite. A strange tasting thing that apparently you spread on bread and can actually eat. No, seriously you can actually eat it. As you can tell – I hate marmite. The smell, the look but most of all the taste. Disgusting! However there are people (I have met them) who love marmite. Interestingly, there are zero people who fall between these two opposing views – you either love it or hate it. Which brings me to the ADO.NET Entity Framework. On twitter I keep seeing ......

Posted On Monday, March 16, 2009 2:35 PM

Data Services team are feeling RESTless - ADO.NET Data Services 1.5 CTP1 announced
ADO.NET Data Services 1.0 was released with .NET Framework 3.5 SP1 and early adopters were impressed with the combination of power and simplicity for exposing RESTful web services in front of ADO.NET Entity Framework (or pretty much anything with a bit/lot of work). However, those same early adopters soon created a long wish list of features they would like the team to add. The good news is they (and you) won’t have to wait until .NET 4.0 to see them included. The team has announced that there will ......

Posted On Friday, March 6, 2009 9:32 PM

Battle of the ORMs slides and links
Today I delivered a session on the ADO.NET Entity Framework as part of a “Battle of the ORMs” session at the Developer Group in Reading, UK. Wasn’t really a battle, more a friendly get together over cake :-) Thanks to all those who attended and to the the other presenters – I learnt a lot! The main links I wanted to share are: Main ADO.NET Entity Framework site including “How To” videos Well written overview article My previous posts on Entity Framework Entity Framework v2 features http://blogs.msdn.com/efdes... ......

Posted On Monday, February 16, 2009 3:21 PM

First published book on ADO.NET Entity Framework
If you are following my blog or watched me present, you know I believe that Entity Framework will be a significant technology for .NET developers (even if EF v1 at times is incredibly annoying!). However we have been hampered by the lack of books available. I am waiting patiently for Julie to have her book published – except I have not been waiting patiently at all! Hence I was really pleased to discover this morning that Joydip now has his book in print, ready to buy in the UK. This covers off Entity ......

Posted On Wednesday, January 21, 2009 5:32 PM

LINQ Overview Concept Map
The world of LINQ in a concept map ......

Posted On Wednesday, January 21, 2009 1:45 PM

LINQ to Entities is the strategic choice
In 2001 we first demonstrated Object Relational Mapping (ORM) technology for .NET – ObjectSpaces. However it has taken 6+ years to get to the point where we have released an ORM. Actually we released two. The release of Visual Studio 2008 in November 2007 gave us our first shipping ORM – LINQ to SQL. The release of Visual Studio 2008 SP1 in August 2008 gave us our second shipping ORM – LINQ to Entities or more specifically, the ADO.NET Entity Framework. Which reminds me of waiting for a bus. You ......

Posted On Wednesday, January 21, 2009 5:26 PM

QandA: How can I use LINQ with new data types in SQL Server 2008 such as the geospatial types?
This one has come up a few times. LINQ to SQL and LINQ to Entities in V1 do not currently support the newest types added to SQL Server 2008 nor do they support your own User Defined Types. More specifically: LINQ to SQL does not support the hierarchyID, geospatial, table or time types. UDTs are not supported. It does support the new DateTimeOffset , DateTime2, and Date types (NB: I have not tried this and I think it may require SP1) LINQ to Entities does not support hierarchyID or geospatial. I haven’t ......

Posted On Wednesday, January 21, 2009 5:21 PM

QandA: How do I debug ADO.NET Data Services?

It is great that so many folks have started investigating Data Services and the Entity Framework as a result of the MSDN events we have been delivering. Which does also mean I keep getting asked “Why doesn’t mine work?” kind of questions.

The good news is the team did a comprehensive post to help you diagnose your issues.

Posted On Wednesday, January 21, 2009 5:19 PM

QandA: How do I use ADO.NET Data Services with LINQ to SQL and enable read/write
ADO.NET Data Service gives you the ability to do: Read/Write with ADO.NET Entity Framework Read only with LINQ to SQL The reason it is read only for LINQ to SQL is that Data Services needs to object model that it is exposing to implement IUpdatable. LINQ to SQL does not. There is a solution – you need implement IUpdatable for LINQ to SQL. This isn’t necessarily as bad as it sounds – if you can narrow down the implementation to how you are using LINQ to SQL. MikeT had a stab at doing just this back ......

Posted On Wednesday, January 21, 2009 5:18 PM

Entity Framework mapping scenarios
One thing I like to get across when I talk about the ADO.NET Entity Framework is that in V1 the Designer does not support all the capabilities of the underlying Entity Data Model (EDM) – and hence you will sometimes need to “roll up your sleeves” and start editing the underlying XML files (CSDL, MSL, SSDL) that make up an EDM. There is a document which will help if you find yourself needing to do this - Entity Framework Supported Mapping Scenarios. Summary: This white paper enumerates the supported ......

Posted On Wednesday, January 21, 2009 2:53 PM

QandA: How to return multiple result sets from a stored procedure using LINQ
This one has come up for both LINQ to SQL and LINQ to Entities. The scenario is a reasonably common one. How to handle something like this: CREATE PROCEDURE [dbo].[ReturnMultipleRS] AS select * from customers select * from products LINQ to SQL: The solution is to add a method to the DataContext using a partial class. Thankfully the Swiss MSDN team have already explained this one in great detail. Enjoy. LINQ to Entities: The easiest approach is to download the ADO.NET Entity Framework Extensions which ......

Posted On Wednesday, January 21, 2009 2:47 PM

LINQ to Relational….
In October 2008 I summarised LINQ to SQL vs LINQ to Entities as: If you only care about SQL Server AND you have complete control of the “shape” of the db schema AND the application will live at most a few years, then LINQ to SQL is a good choice. LINQ to Entities would also work. If you have virtually no control of the “shape” of the db schema OR you are working against a RDBMS other than SQL Server OR you are building an application that will live many years, then LINQ to Entities is the best choice ......

Posted On Wednesday, January 21, 2009 2:43 PM

ADO.NET Entity Framework and Data Services in one slide
I wanted a high level diagram which allowed me to talk about how the technologies worked together, worked apart, cover off areas such as multiple SSDLs, multiple EDMs etc. Not perfect – but proved useful ......

Posted On Wednesday, January 21, 2009 2:37 PM

What you can expect from IUpdateable
In my previous post I explained a little history of why this blog has come about – but now I wanted to explain why the heck you might read it :-) You should expect: Information on the very latest developer related technologies for building applications for Windows – client, server and cloud. A strong bias towards data - Object Relational Mapping, “Data in the Cloud”, Syncing data, RDBMS systems, N-tier data etc. Specifically I will be initially covering the ADO.NET Entity Framework, ADO.NET Data ......

Posted On Wednesday, January 21, 2009 1:39 PM

Copyright © Eric Nelson | Powered by: GeeksWithBlogs.net | Join free