1. The problem comes from that currently Telerik OpenAccess ORM does not support the new data types introduced with SQL server 2008. This feature is scheduled for implementation for Q1 2010.
2. The word Module is a reserved word. That is why your table gets renamed with a number so that it differs from the reserved one. You can change that in the reverse mapping wizard before creating your classes. You can edit the name in the textbox that corresponds to the given class.
3. This pretty much depends on the way you bind your grid. If you are using a DataSource control you should not be experiencing any difficulties. Nevertheless you are able to easily rearrange the order by just reordering the binding columns in the grid definition.
4. You can construct dynamic SQL/OQL to be executed. Here is an example of constructing dynamic OQL query:
|IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
| IQuery query = scope.GetOqlQuery("Select * from " + DropDownList1.SelectedValue.ToString() + "Extent where Name='sad'");
| var result = query.Execute();
| GridView1.DataSource = result.ToList();
5. Currently it is not possible but we are working on new dataform wizards as we speak.
The warning means that OpenAccess is not capable of tracking the changes made to an array field. If you change the whole array with another, the tracking will work, but if you change only one element of the array, it will not. So, to avoid this behavior, the field should be explicitly marked as "Dirty" when such operation occurs. You can use the ObjectScope.MakeDirty(object, fieldName) method to do this.
7. The type FileStream is currently unsupported.
Hope that my answers have shed some light over the work with Telerik OpenAccess ORM. If you have any further difficulties please do not hesitate to contact us.
the Telerik team