Telerik blogs

Latest

  • Productivity

    Using Stored Procedures for CRUD

    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...
    May 27, 2021 4 min read
  • Productivity

    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...
    May 27, 2021 2 min read
  • Productivity

    Handling concurrent database operations with Telerik OpenAccess ORM

    What usually is of great importance to developers that use ORM tools, are issues related to concurrent updates or deletes that can potentially cause a valuable loss of data, and how the ORM framework handles the cases. Because of the state-less nature of HTTP the object-scope is re-initialized on every postback. That is an operation on its own, future blog-posts will cover some of the best practices approaches to object scope life-cycle management. The problem with stateless scenarios is that all change-tracking that the object-scope does for us in a desktop scenario is lost on every postback so there is a...
    May 27, 2021 3 min read
  • Productivity Testing

    Changing the Docking Layout Simulation – WebUI Test Studio for Silverlight Preview

    As the WebUI Test Studio for Silverlight support is going to be released in a few months I was thinking of sharing a preview via a real demo simulation. If you are not familiar with RadDocking for Silverlight, we should emphasize it is one of the most complex Silverlight components out there supporting any layout you might be interested to have. You can find it building the layout of the Bug Tracker Sample Application for example. The video below shows a simulation of a user changing the layout by pure drag and drop actions. This is exactly what one ...
    May 27, 2021 2 min read
  • Productivity Reporting

    Do not filter on null

    This post might seem like a no brainer, but I've received quite a few inquiries on this matter recently, so decided to post here.  Let's say you have a parameter of Type: DateTime with AllowNull: true and we filter on a field based on the input parameter value i.e.: Expression        Operator      Value ===========   ========  ================================= =Fields.MyField        =            =Parameters.MyParam When we tick the 'null' checkbox, it basically filters the report to find the Fields with Nulls. However one might expect that it just won't filter at all with this setup. And indeed if you do not wish to filter, you should not have to. Then how do you handle "empty/blank" values in such cases and...
    May 27, 2021 1 min read