.NET, Visual Studio and Entity Framework blog

Config files specified in SQL Agent being overridden by design time package configuration

In work, our DEV and our UAT DB environments reside on the same box, but with their own SQL instances. We prefer to … Continue reading Config files specified in SQL Agent being overridden by design time package configuration

We’ve implemented Google recaptcha in one of our web apps which is nice and works fine on our local machines. … Continue reading Google recaptcha firewall exception options

As we know using absolute paths in our code can complicate things from a deployment point of view, so it’s … Continue reading Relative path to config file in BIDS/SSIS 2008 package configurations

Matt Briggs has recently wrote one of the best overviews of what it means to be a senior developer that I … Continue reading What do senior developers do differently to other software developers?

I would always favour typing more code to make it more explicit, more readable and to ensure consistency in style … Continue reading Discouraging use of the var keyword and ternary if operator

Cascading deletes and updates are not for everyone and often they can cause problems or are better alternatives to using them. If … Continue reading Get all foreign keys constraints and cascade actions in SQL Server

I recently had a need to test a migration script which converted product IDs from one ERP to those of … Continue reading Restore database backup programmatically with TSQL

Just installed UpdraftPlus to schedule backups of all my WordPress related content including of course the database but also the images, … Continue reading Scheduled WordPress backups with the UpdraftPlus plugin

If you want to have a client-wins or last in wins approach to concurrency management you don’t have to do anything, … Continue reading Using Optimistic concurrency with Entity Framework over SQL Server

If your hosting your site on a Blacknight shared windows hosting account, you’ll likely have either ISAPI Rewrite 2 or ISAPI Rewrite … Continue reading Setting up WordPress permalinks on a Blacknight Windows account with ISAPI Rewrite installed

Right clicking on a web project or a WCF project (others too I’m sure) in Visual Studio presents you with … Continue reading Using MSBuild to publish a website just like in Visual Studio

I was having problems allowing some of my co-workers connect to the instance of SQL Server on my machine. Of course I … Continue reading Can’t receive incoming remote connections to SQL Server database

I was getting page not found errors yesterday when trying to deploy an ASP.Net MVC website which of course worked … Continue reading 404s with ASP.MVC on IIS 7.5

Perhaps your scripting rollout and rollback DDL SQL changes and you want to check for instance if a default constraint … Continue reading How to check if a default constraint exists in SQL Server

If your database queries are taking an age and a half to execute you could do worse than investigate the … Continue reading Introduction to database indexes

Just upgraded to Version 1.2.11 of log4net due to the fact that one of the improvements in this version is … Continue reading Using a connectionStrings section connection with log4net now supported

My last post talked about how to do this for appSettings via the file attribute however as I mentioned in … Continue reading Sharing connectionStrings and appSettings between multiple projects

Many solution structures look a bit like below. This means that if some code in for instance MYSOFTWARE.APPLICATIONSERVICES requires access … Continue reading Common appSettings file for all projects in a solution

Favouring convention over configuration means less change points (and remember points) for developers to deal with when new code needs … Continue reading Register Castle Windsor IOC components via convention