PowerShell and SQL Server Compact 4.0: A Happy Mix

Using SQL Server Compact 4.0 from PowerShell is easy and powerful. Here is an example that shows how to reference the needed libraries, create the database, and add a table to the database – all from PowerShell. 1: $binpath = "C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Desktop\"; 2: [Reflection.Assembly]::LoadFile("$binpath\System.Data.SqlServerCe.dll") 3: $connectionString = "Data Source=’C:\temp\testDB.sdf’;" 4: 5:…

1

ASP.NET MVC: Fun With Routes

For the purposes of this post, let’s say that we are building a community blogging site.  We want multiple users to be able to maintain separate blogs on the site.  We have an area in our MVC application that is called Blogs.  We have a controller in the Blogs area called BlogController and this controller…

0

Visual Studio Testing Extensions now available on NuGet

I have become a huge fan of NuGet lately.  It really makes managing references and dependencies a lot easier. If you are not familiar with NuGet, here is the description from its site: NuGet (formerly known as NuPack) is a free, open source developer focused package management system for the .NET platform intent on simplifying…

0

Book Review – Microsoft .NET: Architecting Applications for the Enterprise

For the entire month of January, I am doing the Daddy Day Care thing for our 4 month old twins.  Since I can’t really work during this time, I figured that it would be a good chance to catch up on some reading that I have been putting off. This book does a fantastic job…

1