Enabling SQLCMD in a Visual Studio Transact SQL Script
So it’s pretty simple but, for some reason, the posts on MSDN that I initially read didn’t include this small but immensely important step. Continue reading
POSTS TAGGED : visual studio
Adding “unknown” file types to your publication package
I’ve been making some updates to a web services project recently (I say recently it was actually months ago but for some reason I haven’t managed to publish this post until now) and the time has come to deploy it to a test environment. This in itself brought a few challenges but the one that I want to discuss just now is the issue of including unknown file types in your publication package. Continue reading
How to Install a NuGet package Without an Internet Connection
If, like me, you are currently working on a development PC that doesn’t have access to the internet it can be a pain trying to install and maintain third party packages. I’m a huge fan of NuGet and I thought that as I didn’t have an internet connected machine I wouldn’t be able to connect to it and download my favourite packages via Visual Studio’s Package Manager. I was wrong though as it’s possible to use Visual Studio’s Package Manager to install NuGet packages even when you don’t have an internet enabled development machine Continue reading
.Net Extension Methods
Extension Methods – What are they?
They are methods written by you which allow you to extend classes that you cannot modify directly. These might be classes you’re using from a third party DLL, or maybe you work in an organisation where your business objects are untouchable by a lowly developer such as yourself (and me), or maybe you just want to add some extra functionality to the String class. If any of these situations ring true then extension methods are something you should know about. Continue reading
Managing Static Data in a SQL Server Visual Studio Project
I’m a fan of the SQL Server project type that ships with Visual Studio having used it over the years with a number of projects. I’ve been away from it for a couple of years though having been working with a company that preferred Redgate’s SQL Source Control offering, so coming back to SQL Server projects again my memory’s been a bit hazy and I’ve struggled how to remember to do some things.
One of these things was how to manage static data Continue reading
Remove Matching Items from a List Using LINQ and Lambda
Removing items from one list that exist in another seems to be one of a developer’s life’s constants so I thought I’d write a short post showing how to carry out this task with the least amount of lines of code. Continue reading