Charlie Ye
February 25th, 2000, 04:49 PM
Hi, All:
Recently, I completed a data access module based on microsoft cutting-age technology, OLE DB. I just posted a trial version of my oledb module on news discussion groups and a number of software developers contacted me if they possibly buy the module with source codes or buy it through a reliable company because my OLEDB module has many attractive advantages over ADO and ATL consumer templates. I think my OLEDB module is marketable and want to market this module through a software company.
If you can help me achieve this purposes or have any concern, please give me a message or suggestion. The following is my address:
Author: Yuancai (Charlie) Ye
Home: 409 Timberlea Drive, Apt# 244
Rochester Hills, MI 48309
USA
Phone 248-652-6838 (H)
Email: yekerui@yahoo.com
Phone 248-853-1800 ext 1800 (O)
Email: cye@sermacrosoft.com(H)
My module is much simpler to learn and to use than ADO and ATL consumer templates, but it delivers best performance you can possibly obtain by OLEDB. The following lists its attractive features and advantages:
CBatchParam: A highly generic wrapper for updating database using a SQL statement or a stored procedure at the fastest speed
1. Supports batch SQL statements with n(1, 2, 3, ....) sets of parameters.
2. Supports batch stored procedures with n(1, 2, 3, ....) sets of parameters.
3. Use the best way to handle n(1, 2, 3, ......) columns of BLOBs no matter whether a OLEDB provider supports multiple storage objects.
4. It is completely dynamic.
5. It's friendly and simple to use, and additionally robust.
6. It has a low foot print (memory).
CBulkRecord: A highly generic wrapper which can handle the toughest SQL statement at the fastest speed.
1. Includes all the functionality of CCommand<CDynamicAccessor, CBulkRowset, CMultipleResults>.
2. Includes all the functionality of CTable<CDynamicAccessor, CBulkRowset>.
3. Supports parameterized SQL statement with one set of parameters.
4. Supports bookmark.
5. Use the best way to handle n(1, 2, 3, ......) columns of BLOBs no matter whether a OLEDB provider supports multiple storage objects.
6. Can dynamically set data type conversion at run time after a CBulkRecord object is opened.
7. It's completely dynamic.
8. It's friendly and simple to use, and additionally robust.
9. It has a low foot print (memory).
10. It's highly extensible.
In addition to the basic functionality, the attached ten examples demonstrate the following special how-tos which may give you headacke:
1. How to generically and dynamically retrieve, delete, insert and update records from and into a DBMS from any SQL statement with or without any number and type of
parameters.
2. How to generically and dynamically use CBulkRecord retrieve n(1, 2, 3, ......) columns of BLOBs, and how to use both CBatchParam and CBulkRecord to delete, insert
and update a table which has any number of columns of BLOBs, no matter whether a OLEDB provider supports multiple storage objects.
3. How to generically and dynamically force an OLEDB provider to convert data types at run time, which is specially handy and makes you coding simpler and generic.
4. How to generically and dynamically use batch SQL statements and stored procedures with any number of sets and any type of parameters for fast deleting, inserting and
updating records.
5. How to generically and dynamically use MS data shiping services associated with any number of tables.
6. How to use bookmarks, scrollable cursors to find records and how to skip forward and back a number of records.
7. How to generically and dynamically use SQL server Batch copy utility.
8. How to extend CBulkRecord and add more functions.
9. How to dynamically create a MS *.mdb file
Recently, I completed a data access module based on microsoft cutting-age technology, OLE DB. I just posted a trial version of my oledb module on news discussion groups and a number of software developers contacted me if they possibly buy the module with source codes or buy it through a reliable company because my OLEDB module has many attractive advantages over ADO and ATL consumer templates. I think my OLEDB module is marketable and want to market this module through a software company.
If you can help me achieve this purposes or have any concern, please give me a message or suggestion. The following is my address:
Author: Yuancai (Charlie) Ye
Home: 409 Timberlea Drive, Apt# 244
Rochester Hills, MI 48309
USA
Phone 248-652-6838 (H)
Email: yekerui@yahoo.com
Phone 248-853-1800 ext 1800 (O)
Email: cye@sermacrosoft.com(H)
My module is much simpler to learn and to use than ADO and ATL consumer templates, but it delivers best performance you can possibly obtain by OLEDB. The following lists its attractive features and advantages:
CBatchParam: A highly generic wrapper for updating database using a SQL statement or a stored procedure at the fastest speed
1. Supports batch SQL statements with n(1, 2, 3, ....) sets of parameters.
2. Supports batch stored procedures with n(1, 2, 3, ....) sets of parameters.
3. Use the best way to handle n(1, 2, 3, ......) columns of BLOBs no matter whether a OLEDB provider supports multiple storage objects.
4. It is completely dynamic.
5. It's friendly and simple to use, and additionally robust.
6. It has a low foot print (memory).
CBulkRecord: A highly generic wrapper which can handle the toughest SQL statement at the fastest speed.
1. Includes all the functionality of CCommand<CDynamicAccessor, CBulkRowset, CMultipleResults>.
2. Includes all the functionality of CTable<CDynamicAccessor, CBulkRowset>.
3. Supports parameterized SQL statement with one set of parameters.
4. Supports bookmark.
5. Use the best way to handle n(1, 2, 3, ......) columns of BLOBs no matter whether a OLEDB provider supports multiple storage objects.
6. Can dynamically set data type conversion at run time after a CBulkRecord object is opened.
7. It's completely dynamic.
8. It's friendly and simple to use, and additionally robust.
9. It has a low foot print (memory).
10. It's highly extensible.
In addition to the basic functionality, the attached ten examples demonstrate the following special how-tos which may give you headacke:
1. How to generically and dynamically retrieve, delete, insert and update records from and into a DBMS from any SQL statement with or without any number and type of
parameters.
2. How to generically and dynamically use CBulkRecord retrieve n(1, 2, 3, ......) columns of BLOBs, and how to use both CBatchParam and CBulkRecord to delete, insert
and update a table which has any number of columns of BLOBs, no matter whether a OLEDB provider supports multiple storage objects.
3. How to generically and dynamically force an OLEDB provider to convert data types at run time, which is specially handy and makes you coding simpler and generic.
4. How to generically and dynamically use batch SQL statements and stored procedures with any number of sets and any type of parameters for fast deleting, inserting and
updating records.
5. How to generically and dynamically use MS data shiping services associated with any number of tables.
6. How to use bookmarks, scrollable cursors to find records and how to skip forward and back a number of records.
7. How to generically and dynamically use SQL server Batch copy utility.
8. How to extend CBulkRecord and add more functions.
9. How to dynamically create a MS *.mdb file