Seems like it should be easy right? It depends which SKU of Visual Studio you have… Option 1: SQL Server Object Explorer If you have a SKU of Visual Studio that includes SQL Server Object Explorer (SSOE) then it’s pretty easy. You’ve probably only got this if you parted with some hard earned cash … Continue reading How to Drop a Database from Visual Studio 2012
Visual Studio
Running EF T4 Code Generation Templates from Command Line
Since EF4 and Visual Studio 2010 you have been able to use T4 templates to generate code from models created using the EF Designer. Starting with EF5 and Visual Studio 2012 T4 based code generation is the default for new models created using the EF Designer. When you create a new model using VS2012 or later … Continue reading Running EF T4 Code Generation Templates from Command Line
Processor named ‘T4VSHost’ could not be found for the directive named ‘CleanupBehavior’
There are two scenarios in which you may see the 'Processor named ‘T4VSHost’ could not be found for the directive named ‘CleanupBehavior’' error after installing Visual Studio 2012 Update 1. Inside Visual Studio when code is being generated from an EF model - this isn't supposed to happen and something probably went wrong during install. … Continue reading Processor named ‘T4VSHost’ could not be found for the directive named ‘CleanupBehavior’
EF CTP4 Tips & Tricks: Find
This is the second in a series of posts taking a quick look at the some of the features in the recent Entity Framework Feature CTP4, also recently dubbed “EF Magic Unicorn Edition”. In the last post we looked at Include with lambda and today we are going to look at the new Find method. … Continue reading EF CTP4 Tips & Tricks: Find
EF CTP4 Tips & Tricks: Include with Lambda
The release of Entity Framework Feature CTP4 was recently announced and included some walkthroughs touching on the core functionality included in the CTP. Over the next couple of weeks I’m going to post up a series of short articles that cover some of the finer points in the CTP. The CTP includes some work called … Continue reading EF CTP4 Tips & Tricks: Include with Lambda
Entity Framework (EF) – Events
Introduction In this post we are going to take a look at some of the events that are raised by various parts of the Microsoft ADO.NET Entity Framework (EF). I’m using the recently released Beta 1 of Visual Studio 2010 / .Net Framework 4.0 for this demo but most of the information also applies to … Continue reading Entity Framework (EF) – Events
NTier with Entity Framework (EF) 4 Beta 1 – (VS2010 / .Net 4.0 Beta 1)
Introduction My blog has been feeling very neglected after my move to the US and I thought with the recent release of Visual Studio 2010 / .Net Framework 4.0 Beta 1 it would be a good time to get back into a regular blogging rhythm. So for the first post I thought I’d run through … Continue reading NTier with Entity Framework (EF) 4 Beta 1 – (VS2010 / .Net 4.0 Beta 1)
Emailing an SSRS Report using ReportViewer
Introduction SQL Server Reporting Services (SSRS) is Microsoft’s offering in the reporting space, if you install SSRS as part of a SQL Server install you get a nice web front end through which users can navigate and view reports. But SSRS is not restricted to this online portal style access, reports can be embedded into … Continue reading Emailing an SSRS Report using ReportViewer
Programmatic ASP.Net Post Back
Introduction This post is somewhat related to my last post that discussed using the Web Dev Server, that ships with VS, to hit ASP.Net web pages from a unit test. In this post I’m going to cover how to fake a user initiated post back from C# code, this example will mimic a button click … Continue reading Programmatic ASP.Net Post Back
ASP.Net Website Tests using Web Dev Server
Introduction One of the great features that came with VS2005 was the Web Dev Server which allows us to run and debug web applications on our development box without the need to install IIS. As with most cool gadgets used by Visual Studio the web dev server is actually also a standalone component that we … Continue reading ASP.Net Website Tests using Web Dev Server
Searchable / Dependant Parameters in SSRS
Introduction The idea behind this post came from a question from a colleague, they wanted an SSRS report where they could select from a list of employees but the list could be filtered by searching on the surname (i.e. you enter ‘S’ and it would load a dropdown of all employees whose surname start with … Continue reading Searchable / Dependant Parameters in SSRS
SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Introduction In this article we will look at the options for using custom .Net code in our Microsoft SQL Server Reporting Services (SSRS) reports. This post assumes you have a working knowledge of SSRS. There are three main ways to use code to help generate our reports, in increasing order of complexity (and therefore flexibility) … Continue reading SSRS Custom Code (Expressions, Embedded Code & External Assemblies)
Horizontally Centred Dynamic Images in SSRS
Centring Dynamic Logos in SSRS This was an interesting problem I ran into the other day, basically I have a report that displays data on a range of businesses. The report then needed a dynamic header to display the logos for each of the businesses that feature in the report. The number of businesses could … Continue reading Horizontally Centred Dynamic Images in SSRS
Invalid value for ‘OSVersion’
If you have a Visual Studio Solution that is failing to build with the error message Invalid value for 'OSVersion' the simplest way to fix this is to set an explicit value for OSVersion in your project file; Navigate to your projects folder in the file system Locate the project file (.csproj for C# .vbproj for … Continue reading Invalid value for ‘OSVersion’
WPF Databinding Overview
Introduction Data binding in WPF seems to be much like skinning a cat (although hopefully a lot less painful… for the cat at least), there is usually more than one way of achieving the result you want. The purpose of this blog is to quickly detail some of the many ways you can bind data … Continue reading WPF Databinding Overview