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.

Database Administration Engineering MySQL PHP Project Management Software Architecture Software Testing SQL

Project ID: #2930005

About the project