Posted on

Portofolio: GetFreeWallpapers.net

Project description:

When trying to find a way to get my hosting expenses covered I started a Wallpaper-site (pretty lame, but still). At this moment I was playing with Linq and wanted to do some with Linq to Objects. At this moment the site creates his own navigation and image view with Linq to Object based on the file-system.

Used technologies:

  • Asp.Net 3.5 
  • Linq to Objects
  • Asp.Net Cache
Posted on

Rabobank starterscommunity live

This week we launched the Rabostarterscommunity. This community is build with Telligent Community Server 2008 and SiteCore 5.

For reporting we uses Harvest reporting service and Google Analytics. 

One thing I learned was that the support of Telligent is not good and also the first releases of CS2008 was buggy, some parts didn’t work at all!!! And don’t even get me started about Telligent Harvest Reporting (Just don’t use it).

If you need to start a community be sure to check if you really need community server! If you only need a forum use: Yetanotherforum.

Posted on

Microsoft SQL Server Database Publishing Wizard 1.1

When I was trying to publish a database to my shared hosting provider I encountered some problems with backup and restoring my database. To restore a database on my provider I needed a full Sql script (schema and data).

After a few attempts with SQL comparer and Management studio I found a link to ‘Microsoft SQL Server Database Publishing Wizard 1.1’. The Publising Wizard does complete backups to SQL script (including data).

When I tried running the Publishing Wizard on my Vista workstation it failed with the following error:
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. An attempt was made to load a program with an incorrect format.

I fixed this error by installing the ‘Feature Pack for Microsoft SQL Server 2005 – November 2005’.

The Publishing Wizard a great tool!

 

 

Posted on

Linq to Sql: Change connectionstring to load from Web.config

Update 20 may 2009: New easy sollution

Set the Connection -> Application Settings property True. This will generate a connection string in your app.config.

 

Copy this connection string to your web.config and your all set!

 

================================================================= 

Old post: 

If you want to use your connectionstring from the web.config with Linq to Sql (dbml) you have to add the following partial class to your project:

[code:c#]

namespace Your.Namespace
{
  partial class yourDataContext
  {
    partial void OnCreated()
    {
       ConnectionStringSettings s = ConfigurationManager.ConnectionStrings["YourConnectionString"];
       if (s != null)
         Connection.ConnectionString = s.ConnectionString;
    }
  }
}

[/code]

Don't forget to change the Your.Namespace, yourDataContext and YourConnectionString to fit your project.

Hope this helps.