Author Archives: david

Visual Studio 2010 Database Projects

Posted on June 15, 2012 by david

I’ve never used a database project in a Visual Studio solution before. In most of the places I’ve worked, the database is managed by full time DBA’s, who deal in sql scripts taylored to make specific schema updates. So i … Continue reading →

Posted in VS2010 | Tagged | Leave a comment

New Info Format

Posted on May 7, 2012 by david

I’ve a been working on the plan to add cheat sheets for the major technologies I work with. I think it would be worth adding example code and projects. Rather than hosting the code on my site I’m going to … Continue reading →

Posted in Uncategorized | Leave a comment

I’m Back

Posted on May 7, 2012 by david

So that was a little odd. I’ve been working as a permi for a bit. My wife and I moved back to Scotland, mostly to be nearer to friends and family. I couldn’t get any contract work up here and … Continue reading →

Posted in Uncategorized | Leave a comment

WAS net.tcp

Posted on December 12, 2011 by david

Another reminder. If you are using WAS to host a WCF service using net.Tcp, make sure the net.tcp listener and net.tcp port sharing services are set to run on the deployment machine. They are disabled by default. Connection refused is … Continue reading →

Posted in WCF | Tagged , , | Leave a comment

ApplicationPoolIdentity and SQL Server Logins

Posted on December 12, 2011 by david

Something I keep forgetting. IIS on 2008R2 has created a special class of user to represent the security principal for code running in an app pool. In the IIS manager the Identity is shown as ApplicationPoolIdentity. The actual user for … Continue reading →

Posted in Server 2008 | Tagged , , | Leave a comment

JQuery and Json with Asp.Net MVC 3

Posted on November 16, 2011 by david

What a sad alphabet soup of acronyms this post has for a title… Just a quick note on using Json ajax requests with asp.net mvc 3. Adding a hnadler for a json request to a controller is easy, the return … Continue reading →

Posted in Uncategorized | Leave a comment

Entity Framework and POCOs

Posted on November 3, 2011 by david

So I finally got around to trying Entity Framework with POCOs, where the domain model objects were hand coded and there was an aleady existing database. The process was initially simple: run the tool that creates a model diagram of … Continue reading →

Posted in EF | Tagged , , | Leave a comment

Git and SSH and Pass Phrases

Posted on November 1, 2011 by david

Continuing with the .Net development under VMware, One useful tip if you use the git bash shell (here) for your version control on windows, and have to access remote repositories over ssh, and you want to skip entering the passphrase at … Continue reading →

Posted in Uncategorized | Leave a comment

XAML Irritation

Posted on October 9, 2011 by david

Can anyone explain the following: <Style TargetType=”{x:Type Button}” BasedOn=”{StaticResource FontStyle}”> <Setter Property=”Template”> <Setter.Value> <!– wont work without respecifying the TargetType…?–> <ControlTemplate TargetType=”{x:Type Button}”> <Border Background=”{TemplateBinding Property=Background}”> <ContentPresenter/> </Border> </ControlTemplate> </Setter.Value> </Setter> </Style> As in – why does the TargetType have … Continue reading →

Posted in Uncategorized, WPF | Tagged , , | Leave a comment

Sum and Count in EF

Posted on October 5, 2011 by david

It bugs me that I need to play around with casting in linq expressions just to make aggregate functions safe. For example: decimal? total = storeDb.Carts .Where(cart => cart.CartId == ShoppingCartId) .Select(c => (decimal ?)c.Count * c.Album.Price) .Sum(); See that … Continue reading →

Posted in EF | Tagged , , , | Leave a comment