Telerik OpenAccess ORM is a tool that supports development of data-oriented software applications. Telerik OpenAccess ORM tool is targeted at solving the object-relational impedance mismatch.
Questions tagged [openaccess]
52 questions
10
votes
4 answers
Compare and Contrast NHibernate and OpenAccess from Telerik
Have you used the OpenAccess ORM from Telerik? How does it compare to NHibernate? When should I consider using it over NHibernate?

Lance Fisher
- 25,684
- 22
- 96
- 122
2
votes
3 answers
Telerik OpenAccess vs. SubSonic in simple speed test (not a "which is better")
I have been using SubSonic 2 for ~5 years now and have loved it. However, for the past six months I've been toying with the idea of moving either to SubSonic 3 or to a similar ORM tool. Since my company uses plenty of Telerik's tools, I thought I'd…

AJ Tatum
- 653
- 2
- 15
- 35
2
votes
1 answer
OpenAccess nuget package and Cannot find resource EntitiesModel.rlinq embedded in assembly exception
We want to remove the necessity of installing OpenAccess on the client and build machine and plan to do that using OpenAccess nuget packages.
I've been following the guide and installed OpenAccess.CodeFirst nuget packages for all projects in…

mrBob
- 385
- 6
- 22
2
votes
1 answer
Enhance UI Responsiveness in c#
I have created an POS application using Dynamic buttons, dynamic table layouts, and other controls in one form. The generated dynamic buttons is based on the number of data queried from the database(using OPEN ACCESS ORM).
My problem is whenever I…

jedion
- 624
- 1
- 7
- 18
1
vote
1 answer
Lock request time out period exceeded - Telerik OpenAccess ORM
I have a big SQL Server 2008 R2 database with many rows that are updated constantly. Updating is done by a back end service application that calls stored procedures. Within one of those stored procedures there is a SQL cursor that recalculates and…

Tys
- 3,592
- 9
- 49
- 71
1
vote
3 answers
DevExpress XPO or Telerik OpenAccess
I'm going to start a mid-sized project and planning to use a good ORM product. I'm going to use a code first approach.
I tried Entity framework, OpenAccess and XPO. I think we're going to buy XPO or OpenAccess. Do you have any suggestions about…

leitmotif
- 23
- 7
1
vote
2 answers
Telerik's OpenAccess ORM and DevArt's dotConnect for Oracle
Has anyone tried to connect to an Oracle DB using DevArt's dotConnect data provider among with OpenAccess ?
OpenAccess works excellent with Oracle.DataAccess.Client, but how about dotConnect?
Is it possible?
Thanks!

Teslo.
- 471
- 2
- 9
- 22
1
vote
1 answer
Telerik OpenAccess and multiple conditions in the where clause
I have just written a few unit tests and to my horror it failed.
Here is my test...
[TestMethod]
public void FetchWithMoreThanOneConditionUsingKnownTypes()
{
using (var scope = EntityObjectScopeProvider.GetNewObjectScope())
{
var temp =…

Rohan West
- 9,262
- 3
- 37
- 64
1
vote
3 answers
How to use interfaces with Telerik OpenAccess
I am trying to implement my persitent classes using interfaces. I have created the following
public interface IFoo
{
int Id {get;set;}
}
public class Foo : IFoo
{
private int _id;
public int Id {get{return _id;} set{_id =…

Rohan West
- 9,262
- 3
- 37
- 64
1
vote
1 answer
How to truncate table using Telerik OpenAccess ORM?
I've tried to
ObjectScope.GetSqlQuery("TRUNCATE TABLE %table_name%", null, null).Execute();
and
ObjectScope.GetOqlQuery("TRUNCATE TABLE %ClassName%Extent").Execute();
The first row does nothing. And the second throw Exception:
line 1:10:…

Enlightened
- 239
- 2
- 13
1
vote
2 answers
DataContractSerializer skip OpenAccess Version's value
I'm using OpenAccess disconnected model. When I try to deserialize an object with DataConractSerializer, the Version property of this object is 0 - but only in the xml. If I debug the code and watch the value - it's 1 (or 2,3...)
If I say before the…

boj
- 10,935
- 5
- 38
- 57
1
vote
1 answer
Which ORM has better performance !! OpenAccess or LLBLGen Pro?
I'm working on a new project right now and thinking of using an ORM beyond that of OpenAccess or LLBLGen Pro or Subsonic.This project may have great quantities and hits concurrent,So our performance requirements is very high.
Please compare and…

guaike
- 2,471
- 9
- 31
- 42
1
vote
1 answer
OpenAccess ORM Fluent API
Suppose I have an assembly A which has all the entities and mappings using fluent api. this assembly needs enhancing, I get it. but what happens to the assembly which is using assembly A. does it need enhancing too?
thanks

Davita
- 8,928
- 14
- 67
- 119
1
vote
1 answer
Telerik DataAccess (OpenAccess) nullable foreign key performance
We are looking for help from people who use Telerik DataAccess ORM. Recently, we encountered a big performance issue with nullable foreign key.
When we assign value to nullable int foreign key property (without SaveChanges) - Telerik makes several…

Artur Ispiriants
- 108
- 1
- 7
1
vote
1 answer
Alternative to TOP or LIMIT clause?
I am looking for an alternative to the TOP or LIMIT clause in the query below. I want the output to be when the engine status changes from its previous value. I am going to union another table on the beginning and end so I can have the first value…

tbst
- 11
- 2