• .NET

    Using LinqPad with Telerik OpenAccess ORM

    July 23, 2009 Share
    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...
  • .NET

    Using Stored Procedures for CRUD

    June 17, 2009 Share
    Telerik OpenAccess ORM generates dynamic SQL to perform CRUD operations. If for some reason you are not comfortable using dynamically generated SQL or your company policies allow data manipulation only via stored procedures, fear not. Telerik OpenAccess ORM supports CRUD operations via stored procedures too – currently only for MS Sql Server, but soon for the other backends also.  Stored procedure usage in Telerik OpenAccess ORM can be classified into 2 categories – Mapping existing stored procedures and instructing Telerik OpenAccess ORM to use them instead of generating dynamic SQL Letting Telerik OpenAccess ORM generate and use the required stored procedures based...
  • .NET

    LINQ 101 Examples with Telerik OpenAccess ORM

    We all know that today LINQ is the most popular and easy way for processing data in the .NET community. In fact you can use almost all data sources you might think of: plain objects, XML or relational databases. While we have been offering an extensive LINQ support for months now, and we are continuously improving it, I don’t think it received the credit it deserves. So we decided to foster the awareness of our community towards the great LINQ support we provide with the Telerik OpenAccess ORM tool. Ok, easier said than done. What approach should we take with this one? A...