|
-
Jun 20th, 2009, 09:29 PM
#1
Thread Starter
Addicted Member
Strongly Typed Dataset functionality
I've written a class that wraps up any database queries with the following added functionality:
Automatic retry on timeout
Automatic reopen on connection closed
Thread Safety
Limited Auto Transfer of data between 2 tables/2 connections/disparate types (including submitting X number of insert statements at once as a batch.) used this one to move 7000 insert statements per trip to the db and moved a 600k+ table close to the speed SSIS achieved. I didn't even make use of threading where SSIS I believe used around 3 threads.
Mapping of some MSSQL, excel, and teradata functions.
Mapping of a few provider's preferred date format.
So I'd like to venture into strongly typed datasets but I Can't seem to find a way to hook generically into any Auto-generated table adapters and use my code, or write new code for these types of functionality that would work with any table adapter. Table adapters inherit from System.ComponentModel.Component so that doesn't expose anything useful for a generic wrapper to make use of =(.
I know table adapters are written as a partial class, but this only allows for snippet based code generation easily. I'd rather have a class-based or generic wrapper based solution.
Any ideas?
Last edited by MaslowB; Jun 20th, 2009 at 10:47 PM.
Reason: grammar/spelling
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|