2012 – Page 3 – Knowledgebase

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

4 October, 2012 Roel van Lisdonk 0 Comments 1 category

When I opened a Microsoft Visual Studio 2010 solution in Microsoft Visual Studio 2012 and debugged my unit tests, some breakpoints where not hit and some code was stepped over, when using F11. The problem

DEV TIPS

1 October, 2012 Roel van Lisdonk 0 Comments 1 category

Just a dump blog post for short development tips. Microsoft Windows 8 Always run pinned programs on the taskbar as administrator If you want the programs pinned on the windows taskbar to always be

How to fix: Count on a group by in LINQ returns 1, when used in a left outer join.

26 September, 2012 Roel van Lisdonk 0 Comments 1 category

If you do a count on a group by in LINQ when using a left outer join, the count will be 1 even though there are no records found for the group. This is caused

How to call a JavaScript function by string name.

18 September, 2012 Roel van Lisdonk 0 Comments 1 category

An excellent answer to this question can be found at: http://stackoverflow.com/questions/359788/how-to-execute-a-javascript-function-when-i-have-its-name-as-a-string I knew you could call a JavaScript function by it’s string name, by using window[‘functionName’], but this does not work for namespace functions. When

How to make Entity Framework 5.0 use an in-memory persistence DbContext instead of accessing the database.

23 August, 2012 Roel van Lisdonk 5 Comments 1 category

If you want to switch between in-memory stub data and a database during runtime with Entity Framework 5.0, you have several options, some of them are: – Using a second level cache mechanism like http://www.codeproject.com/Articles/435142/Entity-Framework-Second-Level-Caching-with-DbConte

How to convert / cast the current server date and time to a varchar in the format YYYY-MM-DDThh:mm:ss[+|-]hh:mm in T-SQL

13 August, 2012 Roel van Lisdonk 0 Comments 1 category

To convert the current machine date and time to a varchar in the format YYYY-MM-DDThh:mm:ss[+|-]hh:mm in T-SQL, you can use the following code: select convert(varchar(100), cast(sysdatetimeoffset() as datetimeoffset(0)), 126) Result (in Amsterdam in

Only creating a schema, when it does not exist in a Microsoft SQL Server database.

17 July, 2012 Roel van Lisdonk 0 Comments 1 category

If you want to create a schema in a Microsoft SQL Server database only when it does not exist, use: declare @SchemaName nvarchar(128) set @SchemaName = 'Staging' if not exists(select top 1 1 from information_schema.schemata

Fix / restore user and login mappings in SQL Server

17 July, 2012 Roel van Lisdonk 0 Comments 1 category

If you restore a SQL Server (< 2012) database on an other database server make sure you fix the user and login mappings by following the steps on http://atakala.com/browser/Item.aspx?user_id=amos&dict_id=2036 Short fix: use MyDatabase go sp_change_users_login

How to fix: Can’t drag and drop custom Team Foundation Build Activity on XAML build process template in Microsoft Visual Studio 2010.

12 July, 2012 Roel van Lisdonk 0 Comments 1 category

A .NET 4.0 assembly containing a custom Team Foundation Build Activity can only be dragged and dropped from the toolbox on your build process template XAML file, when it is first registered in the GAC.

How to correctly use select top 1 inside a inner join of an update statement in T-SQL.

11 July, 2012 Roel van Lisdonk 0 Comments 1 category

And the answer is: don’t use select top 1, instead use the row_number() function and the OVER clause. Lets assume we have a table structure like: Table [Observation] Multiple observations during a TimeSpan

Year: 2012