Welcome to MSDN Blogs Sign in | Join | Help

Simon Ince's Blog

Ramblings of an Application Development Consultant in the UK

Browse by Tags

All Tags » SQL » MSArchitectPortal   (RSS)
Flattening XML Data in SQL Server
If you’ve got some XML data in a SQL Server column, how can you flatten it out and query it or present it as though it was relational data? It turns out this is quite easy... Setup Let’s create a simple table to hold our data; CREATE TABLE XmlSourceTable Read More...
Mapping two Tables to one Entity in the Entity Framework
Whilst at Q-Con a few weeks ago someone asked me about how to map two database tables to one entity in the Entity Framework... something a lot of people want to do at some point or another. At this point I must thank Chris Barker for pinging me some links Read More...
Page view tracker