Yes, generally accessing the database with stored procedures only is possible.
However, what we actually have is not CRUD mapping, but CUD mapping (notice that the R is missing).
Now, depending on the version of OpenAccess and the approach that you are using there are two options:
1. If you are using the ObjectScope, basically what you can do is configure CUD mapping and also have your stored procedures for reading mapped so that they return strongly typed results.
You could take a look at the following example (there is also a video):
The example should also clarify what the stored procedures should look like.
2. If you are using the new visual designer, unfortunately you cannot use the CUD mapping as there is no way currently to map the reading stored procedures so that they return strongly typed result (we are working on that). In this case you will have to map all your stored procedures in the context (and not on the persistent classes).
I hope this helps. Do not hesitate to write again if you have more questions or suggestions.
the Telerik team
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Public Issue Tracking
system and vote to affect the priority of the items.