Build Specialized Result Set Component in .NET

What I am looking to create is a VistaDB version of the SQLCeResultSet component provided by Microsoft in SQL Server CE.? I need a speedy, scrollable, updatable, bindable cursor data source that accesses underlying VistaDB 3.5 databases and provides the features present in SQLCeResultSet.

VistaDB can be found for ? information at [url removed, login to view]

## Deliverables

Create a component named VistaDBResultSet that implements all of the interfaces and methods of Microsoft’s SQLCeResultSet.? See <[url removed, login to view]([url removed, login to view]).aspx> for details.?

The component will access VistaDB 3.5 and newer, see [url removed, login to view] for information on this product. ? I will provide you access to a demo or full version of VistaDB for your development purposes.

?

Create this component using .NET 2.0.

?

Create this component using Visual Basic, with OPTION STRICT ON and OPTION EXPLICIT ON. ? Alternatively, upon request, I will consider and approve C#

?

Since SQLCECommand is not available to create the result set with its ExecuteResultSet method, set up the constructor of this class to accept:

? ? ? ? ? A VistaDBCommand that has been set up with SQL

? ? ? ? ? The same ResultSetOptions that are available for SQLCeDataSet

? ? ? ? ? A String error message

? ? ? ? ? …and return the VistaDBResultSet.? If there is an error populate the error string and return nothing.

?

Implement the complete interfaces of a SQLCeResultSet, and also implement iDisposable and dispose of any datasets, etc., that you use to accumulate results. ? You need to clean up.

Test the work for accuracy? in binding to DataGrid and DataGridView, and in allowing updates in? them.

The goal is to have a scrollable, updatable, bindable datasource that can operate on VistaDB SQL Queries. ? Updatability not to be supported on multi-table queries, you do not need to code for this.

The faster you make the control, the better, but I also understnd the limitations of VistaDB in terms of not having a bidirectional or scrollable cursor, and forcing you to use a datareader.

?

Time and accuracy are of the essence in this project. ? I need you to give me an HONEST and REALISTIC deadline estimate of the time it will take.

数据库管理 工程 MySQL PHP 项目管理 软件构架 软件测试 SQL

项目ID： #2930005

关于项目