March 2012 – Knowledgebase

How to validate a XML file against a XSD file, including the referenced schemas by the XSD file in C#.

30 March, 2012 Roel van Lisdonk 3 Comments 1 category

If you want to validate an XML file against a XSD file and use the XSD schemas referenced by the XSD file in the validation, you can use the following C# code: using System;

How to name primary key and foreign key constraints, when creating a table with T-SQL.

26 March, 2012 Roel van Lisdonk 0 Comments 1 category

When trouble shouting error’s thrown by T-SQL, naming your primary and foreign keys, proves to be handy. When creating tables with T-SQL, I use the naming format PK_MyTable_MyColumn1_MyColumn2 and FK_MyTable_MyColumn3_MyColumn4: if object_id('[dbo].[Address]') is null begin

How to change the .mdf and .ldf location of an online Microsoft SQL Server LocalDb database in a Microsoft Visual Studio 2010 test.

23 March, 2012 Roel van Lisdonk 0 Comments 1 category

For testing purposes it is possible to copy a new localdb database to your output directory and start using this localdb database. For more information see my previous post: http://www.roelvanlisdonk.nl/?p=2607 It is possible that a

Using SQL Server 2012 LocalDb in VS11 and VS2010 for testing.

19 March, 2012 Roel van Lisdonk 2 Comments 1 category

To create high quality LOB applications unit tests and integration tests are mandatory. You want to run these integration tests and unit tests on your continuous integration server. The problem with integration tests or testing

Developer License Windows 8 consumer preview

16 March, 2012 Roel van Lisdonk 0 Comments 1 category

Well I better start start pushing my new Windows 8 apps to the windows store Created a new developer license at 16-3-2012 and now I can create apps until 15-04-2012.

TIP: Microsoft Windows 8 keyboard shortcut to shutdown, restart or sleep your pc.

16 March, 2012 Roel van Lisdonk 0 Comments 1 category

Keyboard shortcut for shutting down your Windows 8 pc: [WINKEY] + I, [UPARROW], [ENTER], [u] Keyboard shortcut for restarting your Windows 8 pc: [WINKEY] + I, [UPARROW], [ENTER], [r] Keyboard shortcut for sleeping your

How to use content files from another project in a Visual Studio unit test, by using DeploymentItems.

13 March, 2012 Roel van Lisdonk 0 Comments 1 category

To access a file from another project in a Microsoft Visual Studio unit test, without specifying the absolute path, you can use DeploymentItems. DeploymentItems DeploymentItems are files that will be copied to the

How to convert a bitmap into a 1bpp monochrome TIFF in C#

9 March, 2012 Roel van Lisdonk 3 Comments 1 category

If you want to convert a bitmap into a TIFF, than then you can use the code: using (System.Drawing.Bitmap sourceBitmap = new System.Drawing.Bitmap(@"C:\Temp\Source.bmp")) { string outputFileName = @"C:\Temp\Destination.tiff"; if (System.IO.File.Exists(outputFileName)) { System.IO.File.Delete(outputFileName); } sourceBitmap.Save(outputFileName, System.Drawing.Imaging.ImageFormat.Tiff);

Tip for Windows 8 CP users, what to do when the start screen doesn’t respond any more.

8 March, 2012 Roel van Lisdonk 0 Comments 1 category

I ran into some cases, where the Windows 8 CP start screen didn’t respond any more. When I clicked on a title, the tile would show the “button click transformation”, but would not start any

How to update an entity in the database, when state tracking is disabled in Entity Framework 4.3

8 March, 2012 Roel van Lisdonk 0 Comments 1 category

When you disable state tracking in Entity Framework 4.3, for performance improvements (and you know what you’re doing ), by setting: DbContext.Configuration.AutoDetectChangesEnabled = false , then you are responsible for your own state tracking on

Month: March 2012