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 [login to view URL]
## Deliverables
Create a component named VistaDBResultSet that implements all of the interfaces and methods of Microsoft’s SQLCeResultSet.? See <[login to view URL](VS.80).aspx> for details.?
The component will access VistaDB 3.5 and newer, see [login to view URL] 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.