# Modified SQLHelper for .TEXT 0.94

<datetime class="hidden">2004-01-29T00:00</datetime>
<!-- category -- mostlylucidcouk, Imported, C#, Database, ASP.NET -->

I am in the middle of developing a couple of new controls to work with this site (first up is a booklist which works with the amazon.co.uk web service), as part of this I need to have data access. I was having a look at the current SQLHelper class in the DotText.SqlDataProvider namespace - it is basically the same as the [Data Access Application block](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp) but has a couple of useful methods missing (e.g., the SqlParameterDataCache which I use a LOT - cuts down on typing :-)). As a result of wanting to use these methods whilst still using the same class, I have modified the SqlHelper class to be identical to the [Application Block](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp)version, but with a few methods added to make it compatible both with [.TEXT](http://scottwater.com/DotText/) and with my exisitng controls using the basic [Application Block (V2)](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp).
I'll update this post later with some more links...anyway, you can download my modified version from [here](/uploads/SqlHelper.cs.txt).
I'll probably modify my design later to be a bit more architecturally 'pure' but I have a dilemma, as this will mean modifying the basic [DAAB](http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnbda/html/daab-rm.asp) to be non-sealed...hmm...any opinions??? 
I'm also working on a simple OPML display control which works nocely with .TEXT (i.e., lets you upload an opml file which will then display on the appropriate blog...), I know of a few existing OPML parsers and have actually written one previously so hopefully it won't take too long!