Deploying SqlServerCe with an ASP.NET MVC application

Using Entity Framework Code First together with SqlServerCe is a great way to work with small databases in ASP.NET MVC applications. I have several web applications running on shared hosting sites where SqlServerCe is the database engine under the hood. Deploying is also quite easy. I typically use the build in Publish Web option which works great over FTP.   When using SqlServerCe you have to make sure you add the deployable dependencies. Forgetting those results in pretty clear error messages.   However once that is done I always run into another issue. When a page actually tries to use … Continue reading Deploying SqlServerCe with an ASP.NET MVC application

Updated SQL Server Compact Workflow Persistence Service

Yesterday I uploaded a new version of the SQL Server Compact Workflow Persistence Service to No major changes this time just two new features to get it more in line with the standard SqlWorkflowPersistenceService. I added a GetAllWorkflows() function that returns all persisted workflow’s in the database. I added a LoadExpiredTimerWorkflowIds() function that will return a list of workflow instanceId’s of all workflow’s with an expired timer. Both new functions should help make the SqlCeWorkflowPersistenceService even more like the out of the box SqlWorkflowPersistenceService. And as before it is completely free [:)]. You can download the source code for … Continue reading Updated SQL Server Compact Workflow Persistence Service

PDC session download

Want to download and watch all PDC content? Then there are a couple of ways to get at them. The official way if to go through the session agenda at the conference site. See You see all sessions but it takes a bit of work. Another nice way is through Channel 9 by using the following feed: But the best as far as I am concerned is using the list compiled by Greg Duncan. Check this list And it even has the Visual Basic source code used to generate the list [:)] Enjoy the videos! [f1][f2]

Red Gate to continue development of .NET Reflector

.NET Reflector, by Lutz Roeder, must be one of the most useful tools I have when developing .NET code. Usually it is the first thing I install right after Visual Studio not even waiting until I need it because I know I will. So the big news is that Red Gate, makers of the Ants profiler and lots of other tools, are taking over from Lutz Roeder and will continue developing .NET Reflector. Interesting move and I hope this means a bright future for the .NET Reflector. Read more about this here.   Enjoy!   [f1][f2]

.NET Framework 3.5 Enhancements Training Kit

Want to know what is new in the .NET 3.5 SP1 framework or Visual Studio 2008 SP1? Then check out the presentations and labs here:   Overview The .NET Framework 3.5 Enhancements Training Kit includes presentations, hands-on labs, demos, and event materials. This content is designed to help you learn how to utilize the .NET 3.5 Enhancement features including: ASP.NET MVC, ASP.NET Dynamic Data, ASP.NET AJAX History, ASP.NET Routing, ADO.NET Data Services, ADO.NET Entity Framework, WCF 3.5 SP1, and the .NET Framework Client Profile.   Now this is nowhere near complete but a good place to start.   Enjoy!

SQL Server Compact 3.5 SP1 released

Steve Lasker just announced that SQL Server Compact 3.5 service pack 1 is released, read his announcement here. They added support for the entity framework, great stuff. And another neat feature is native 64 bits support. No longer do you need to target X86 and use WoW [:0]. Great if you are using my SQL Server Compact Workflow Persistence Service. Enjoy!

CodeCamp 2008

Afgelopen jaar hebben we het eerste CodeCamp in Nederland georganiseerd en dat was een groot succes. De meeste deelnemers vroegen om meer, sommige zelfs om een CodeCamp per kwartaal of een heel weekend lang. Nou hebben we dat laatste nog niet gedaan maar we zijn wel aan de slag gegaan om een nieuw CodeCamp te organiseren. Als datum hebben we zaterdag 6 september gekozen. Gelukkig waren Microsoft en Class-a behulpzaam en kunnen we, net als vorig jaar, weer in het Microsoft Innovation Center in Barneveld terecht. Een mooie datum en locatie om uitgerust van de vakantie een hoop kennis uit … Continue reading CodeCamp 2008

SQL Compact 3.5 on a 64 bit Windows

SQL Compact is a great little database and highly recommended. However it was designed for use on small compact, hence its name, devices and that has some drawbacks. One of these is that it doesn’t run as a 64 bits application. And by default if you create a .NET application it is compile as “Any CPU” meaning it will run as a 64 bits application on a 64 bits version of Windows. I, or I should say Ron Jacobs, ran into that using my SqlCeWorkflowPersistenceService because the sample/test application  was set to the default of “Any CPU”. The result is … Continue reading SQL Compact 3.5 on a 64 bit Windows

SQL Server Compact Workflow Persistence Service updated

I have just updated the SQL Server Compact Workflow Persistence Service to better handle deserialization issues when loading a workflow. The service now makes sure the WorkflowRuntime ServicesExceptionNotHandled is raised, something it should have done in the first place. You can download the SQL Server Compact Workflow Persistence Service from here.   Enjoy! www.TheProblemSolver.nl