Archive for September, 2008
.NET and spatial data (with SQL Server 2008), part 2
The other day I published a post about the spatial data support in SQL Server 2008 and using the new data types in a .NET application. I decided to write about “the rough way” and promised to publish an article about how to use DataSet designer and TableAdapters… Here it is!
I will try to present an example to accomplish the same result as in .
.NET and spatial data (with SQL Server 2008), part 1
As I wrote in my post the other day about SQL Server 2008, I would present some examples on how to use some of the new data types supported in SQL Server 2008 when developing .NET applications.
I “googled” the subject and found a couple of blogs about it. I wasn’t able to find anything on MSDN, except on the Forums. The information on the forums was somewhat useful, so I started off…
SQL Server 2008
Today I downloaded and installed SQL Server 2008, both the Express and Standard Edition. The first thing I noticed was the huge files to be downloaded. The Standard Edition was almost a full DVD, a little bit more than 3 GB, while the Express Edition was about 500 MB.
The install process is a little bit tedious involving two reboots. The first is needed after a hotfix install (Windows installer 4.5) and the other one is needed after the installation completes. This goes for both Standard and Express Edition. When installing the Express Edition you have to separately download and install Windows PowerShell.
This doesn’t sound as a good start for this database engine, but if you survive the installation there are a lot of nice stuff waiting for you…
Windows event log and web applications
When developing and running web applications, such as web sites or web services, it is nice and convenient to have some logging from the application. Instead of using a log file it would be nice to be able to use the built-in event log in Windows.
When running or debugging a web application from Visual Studio using the built-in web server, named WebDev.WebServer.EXE when looking in the task manager, it will cause no trouble logging to the event log but when publishing the site or service to a server environment, Windows 2003 Server and IIS, it will cause the application to crash. The IIS log file will show an error, status 500, indicating an internal server error. The application will crash due to insufficient permissions for the application to write to the event log.
Don’t worry! There are a couple of solutions to this and I will present one of them here, with the ability to be treated as a little tool for those who develop .NET web applications.
ASP.NET MVC Preview 5 Release
On the ASP.NET CodePlex web site I found that ASP.NET MVC Framework was released, preview 5, the other day.
As I have written in earlier posts about the MVC Framework I will try it out by using it in one of my hobby projects. So far I haven’t got the time to start this project but soon, really soon…