No Sorting Support

[vb]

I spent the weekend taking a very close look at Telerik Data Access (Q1 2015) as a possible ORM for a new project. It would be difficult to use Entity Framework because the backend is SQL Server 2000.

I was very disappointed to find that, although TrackedBindingList (Of T) implements IBindingList, it does not support Sorting, nor Searching, nor AdvancedSorting, and it does not implement IBindingListView.

I was also disappointed to find that when a collection of top level entities (IQueryable(Of T)) are bound to a DataGridView, there is no support on the BindingSource for .AllowNew.

When I bound a Navigational Property to a DataGridView, the BindingSource.AllowNew was True. However, entering a new record in the grid and attempting to save on the context resulted in the following DataStoreException:

Insert of '39711351-' failed: System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
   at Telerik.OpenAccess.RT.Adonet2Generic.Impl.PreparedStatementImp.execute(Nullable`1 commandTimeout)
   at OpenAccessRuntime.Relational.conn.PooledPreparedStatement.execute(Nullable`1 commandTimeout)

There is one non-nullable Date property in the type bound to the row in the grid. I supplied a valid Date value when adding a new record in the grid.

Please let me know if you have plans in the (very) near future to fully implement IBindingList or, better yet, IBindingListView on your TrackedBindingList object. It is possible of course that I'm missing something fundamental here in testing this framework. If so, please let me know.

[Doroteya]

Hello,

Regarding the error you are experiencing, the provided information is insufficient for me to determine the cause for it. Therefore I ask you for your cooperation. Could you provide me with the code that produces it along with details about the database table that holds the Date column and the persistent entity to which the table is mapped?

If I understand the scenario you are implementing correctly, you are trying to insert new records in the database through a new row in the grid. If so, this forum post will provide you with a sample workflow for the implementation.

As for the improvements you mention in the support of IBindingList, currently our roadmap does not include such. Nevertheless, you can add a feature request on our Ideas and Feedback portal.

I hope this helps.



Regards,
Doroteya
Telerik