Telerik blogs

Tag: Telerik Data Access

  • Productivity

    Using the ObjectContainer in disconnected scenarios – Part 2

    How to get objects into the ObjectContainer? The ObjectContainer contains a closed world of instances, no reference is dangling and pointing out of the container. That means, the instance graph is contained completely in this 'workspace'. Of course, at some points the need arises to prune the graph, as otherwise the whole database content would need to be stored in the containers memory. This is no different to the connected IObjectScope, but in the scope, we can directly perform the loading of objects from the database (lazy loading). With the container, there is no connection to a database,...
    May 27, 2021 3 min read
  • Productivity

    Using LinqPad with Telerik OpenAccess ORM

    LinqPad is a nice and popular query analyzer made to test LINQ queries: whether it is Linq To Sql, Linq to Objects or some other flavor, you will be able to play in a nice way with it. Sadly it does not support Telerik OpenAccess ORM out of the box. However we never said it is impossible – you just have to put some more pressure to it. So, the first step is of course to deploy Telerik OpenAccess ORM and LinqPad on your machine. Then do the following: a) Open LinqPad and press F4 to bring up the Advanced Query...
    May 27, 2021 2 min read
  • Productivity

    LINQ Tip of the Week: Optimizing query execution by using parameterized queries

    This is the first post of the series that have the goal to help Telerik OpenAccess ORM users enhance their experience in Linq against OpenAccess persistent objects. The two areas where performance enhancement can be taken advantage of are reusing a Linq query from the query cache and altering the query in a way where bigger portions of it are executed on the server. Today we will share with you a tip about the first one. When a Linq query is requested for execution, the query goes through a step of compilation – where the Linq query expression tree...
    May 27, 2021 2 min read
  • Productivity

    Tracing the SQL Statements Generated by Telerik OpenAccess ORM

    One of the main jobs that the ORM software should handle is communicating with the database server and generating SQL statements for reading and writing data. Undoubtedly, the performance of each application developed by using an ORM tool depends on the generated SQL. It is a responsibility of the ORM software to optimize each statement and avoid unnecessary queries. So, when you are facing a difficult choice of an O/R Mapper, it is always meaningful to see and compare how your data is treated by different products. However, not all database engines are distributed with additional profiling software for observing...
    May 27, 2021 3 min read
  • Web

    Read only classes and fields

    If a table or a view is mapped where the user does not have the rights to change data, it is not helpful that the exception is thrown during commit. Sometimes it is hard to find the place where the write access is done. Those exceptions can now be enforced to be thrown during the write operation itself. The attribute can be set at class level but the wizard does not contain it. In the Q2 release you have to do it by hand, the Q2 Sp1 will contain the UI. The settings on class level are: "readwrite": The default, everything is...
    May 27, 2021 2 min read
Prev
... 31 32 33 34 35 36 37 38 39 40 ...
Next