October 2012 – Knowledgebase

How to drop a foreign key based on a table name and column name with T-SQL.

23 October, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to delete a foreign key based on a given table name and column name in T-SQL, you can use the following code snippet: Full table name = [MySchema1].[MyTable1] Full column name =

Fixing the error: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to ‘GroupJoin’. in a left join with LINQ.

19 October, 2012 Roel van Lisdonk 0 Comments 1 category

If you do a left join in LINQ on multiple columns / properties. The types and names of these properties must be the same else you will get the error: The type of one of

How to update a property of an object in LINQ without returning new objects.

18 October, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to update an property of an object in LINQ without creating new objects, you can use the following code: using System; using System.Collections.Generic; using System.Linq; using Microsoft.VisualStudio.TestTools.UnitTesting; using Assert = Xunit.Assert; namespace

Month: October 2012

How to drop a foreign key based on a table name and column name with T-SQL.

Fixing the error: The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to ‘GroupJoin’. in a left join with LINQ.

How to update a property of an object in LINQ without returning new objects.

How to restore a database on a Microsoft SQL Server LocalDb instance, based on a *.bak file.

How to copy files from host to a Hyper-V virtual machine in Windows 8 by using the clipboard.

How to clone / copy a Windows 8 Hyper-V client virtual machine

Fix for: Some breakpoints in Microsoft Visual Studio 2012 unit tests are not being hit.

DEV TIPS