Welcome to EMC Consulting Blogs

Browse by Tags

• .NET
• Data Access
• LINQ
• LINQ to SQL
• SQL CLR
• SQL Server
• SQL Server 2008
• SQLBits
• Windows Phone 7
• WP7

• Thoughts on Windows Phone 7 Development

  For the SQLBits 7 conference last weekend I wanted to show spatial data and built an app that displayed data on a Windows Phone. I wanted to investigate the mobile side of the ‘three screens and a cloud’ mantra and succeeded by building an application Read More... Posted 11 October 2010 12:03 by simon.munro | 0 Comments Filed under: C#, SQLBits, WP7, Windows Phone 7

• Getting SQL Certificates Directly from the Database

  I have a requirement, for service broker endpoints and queues, to automate the creation of a certificate on one server and load them up on another.  The manual way of doing this is something like this: 1. Use CREATE CERTIFICATE to create a self signed Read More... Posted 12 December 2008 17:33 by simon.munro | 0 Comments Filed under: SQL Server, C#, SQL Server 2008, SQL CLR, .NET

• User Count - A TDD and LINQ update to a classic

  This t-shirt has been around for years... So I thought that it needed a bit of an update. Assert .AreNotEqual(0, users.Count(u => u.clue > 0)); Simon Munro Read More... Posted 05 December 2008 09:16 by simon.munro | 2 Comments Filed under: C#, .NET

• Digging in the SQL CLR Litterbox

  When the SQL CLR, a technology enabling .net assemblies to be called from within SQL Server, was released in 2005 a collective gasp went up from DBAs all around the world.  And rightly so, the idea that developers would be writing rogue little .net Read More... Posted 12 November 2008 17:13 by simon.munro | 1 Comments Filed under: SQL Server, C#, Data Access, SQL CLR

• Move over LINQ to SQL - you have served your purpose

  As the PCD2008 hangovers wore off the announcements of the week were overshadowed by the apparent axing of LINQ to SQL. It all started with a post by Tim Mallalieu , where he stated : We’re making significant investments in the Entity Framework such that Read More... Posted 02 November 2008 22:38 by simon.munro | 10 Comments Filed under: SQL Server, C#, LINQ, LINQ to SQL

• Comparing Arrays with LINQ

  I needed to compare the contents of two arrays to see if they were the same.  Obviously Equals won't work because they are different objects and although it would be easy enough to write a little routine to iterate through the arrays I thought that Read More... Posted 23 October 2008 09:41 by simon.munro | 2 Comments Filed under: C#, LINQ