Using UpSert in EF4 with SQL Merge Statements


In less than 15 minutes we will create a stored procedure that utilizes the SQL 2008 Merge statement and map it with Entity Framework 4; allowing you to use modern code while keeping the old school DBA’s happy.

Ken Lovely

Ken is an innovative Information Architect with 20 years’ experience specializing in Microsoft platform technologies. He holds several Microsoft certifications; MCSE, MCPD, MCDBA, MCTS. He has designed and developed systems for financial, banking, cable and insurance industries.  He has strong system development and diagnostic skills. He has been training developers for 10 years. Besides developing data systems Ken also programs lighting software that he uses to light up his neighborhood at Christmas time – www.lovelychristmaslights.com