Archive for the '.NET' Category
(Chronologically Listed)
Six months in a leaky boat
Yesterday I discovered a potential resource leak when using the dbExpress Ado.NET provider, which can cause connections to be created and never freed. This leak was discovered when I implemented and started consuming a helper method which allows me to easily determine whether a data reader contains a specified column.
class method DbUtils.ColumnExists(AReader: DbDataReader; AColumnName: String): [...]
Migrating IIS7 configurations
In the process of setting up my development environment on a new laptop, I was looking for a way to migrate my IIS7 configurations from the old laptop, so I didn’t have to manually configure the many web applications and virtual directories required in my day to day development duties. As there was no obvious [...]
Posted by David Clegg on April 16th, 2009 under .NET, ASP.NET, IIS | 4 Comments »Using String Attributes in ECO IV dbExpress Applications
Today I was converting an ECO III application originally written in Borland Developer Studio 2006, to an ECO IV application using RAD Studio 2007, when I stumbled across an interesting problem. The application talks to an InterBase database, and was using the Borland Data Provider components for its database connectivity. While BDP is still included [...]
Posted by David Clegg on March 18th, 2008 under .NET, Database, Delphi, ECO | 1 Comment »Dispose considered harmful
I discovered an interesting memory leak in one of my Delphi.NET services the other day, with the leak occurring in a manner I hadn’t encountered previously before. I narrowed the source of the leak down to the database polling threads, which all contained pretty much the same logic. They would create a connection to an [...]
Posted by David Clegg on February 12th, 2008 under .NET, Database, Delphi | 6 Comments »Installing a Delphi for .NET Windows Service
In the borland.public.delphi.language.delphi.dotnet newsgroup today, I noticed a post from someone enquiring how to create a Windows service using Delphi for .NET. While there are plenty of references about this subject on the internet, such as the "Writing a Useful Windows Service in .NET in Five Minutes" blog entry that Craig Stuntz directed the poster [...]
Posted by David Clegg on January 23rd, 2008 under .NET | 3 Comments »ECO: The next big thing in comedy
I often feel a lot of different emotions when using ECO, including happiness, smugness (knowing all the other suckers are coding the hard
way) and frustration (usually due to inexperience :-)). But today it invoked another emotion… laughter.
I was attempting to use the IOclPsService to execute an OCL statement when I was greeted with the following [...]
Why can’t we call ‘em as we see ‘em?
One of my pet peeves as a developer are exception messages that mask the true reason behind a particular exception. I was reminded of this just now after finally discovering the cause of a bug which I’ve been trying to stomp on for the last hour.
I’ve been writing some classes to talk to an Oracle [...]
Using an expiring cache in VCL.NET applications
When developing ASP.NET applications, it is common to take advantage of the System.Web.Caching.Cache class to cache items for later retrieval. It is also possible to have these cached items expire at a given time or after a specified period. You can even have an event raised when this expiration happens, which can be handy [...]
Posted by David Clegg on October 24th, 2007 under .NET, Delphi | 1 Comment »Reflection is your friend
A post by Troy Wolbrink in borland.public.delphi.non-technical about how he had used reflection to use a custom resource manager, reminded me of a situation recently where Reflection had also come to my rescue.
I was designing a static class to assist with the parsing and retrieval of command line parameters, and was designing a unit test [...]
Debugging BlackfishSQL Stored Procedures
I’ve been spending a bit of time with BlackfishSQL over the last couple of days, and in particular have been developing stored procedures for it. Initially I had a couple of problems when attempting to debug these stored procedures in the IDE. I thought I’d blog about them here, along with how I got around [...]
Posted by David Clegg on October 9th, 2007 under .NET, Database, Delphi | Comment now »
RSS Feed
Connect with Us