Telerik blogs

Latest

  • Productivity

    Migrating data from one database server to another

    In today’s post we are going to discuss a topic which is known to be fairly complex in most cases but it is relevantly easy to be achieved with Telerik OpenAccess ORM. Let us consider the following scenario: your company decides to move your data access from one database server to another.  So you have your database in a MSSQL Server instance  and want to migrate to MySql. The schema is the same on both servers but the data resides inside  the MSSQL Server instance. What follows is the easiest way to move all the data from the MSSQL server database to...
    May 27, 2021 2 min read
  • Productivity Reporting

    Horizontal Table for your reports

    Recent question that popped up from an user was how to create a table, where the table grows horizontally instead of vertically. This is easy as one, two, three when using our Table report item. I start off using the crosstab item as initial template for this task. As the table would be growing "in columns" instead of "in rows", we do not need a row group so we delete it. Then bind the crosstab to a sample business object making sure we've added as many static rows as we need. Next step in order to show all the data, we need to make sure that...
    May 27, 2021 2 min read
  • Productivity

    The Telerik CAB Enabling Kit and SCSF - Tutorial 6: The RadTreeView UIExtensionSite

    Welcome to the sixth tutorial in my series of tutorials about the Telerik CAB Enabling Kit. This week, we will learn how to use the RadTreeView UIExtensionSite. I will be using a TCEK enabled Smart Client Application as the base for this tutorial. I’ve also create a simple module called the Settings module that I will use in this tutorial. Adding the RadTreeView UIExtensionSite To add the RadTreeView UIExtensionSite, the first step you will need to take is to simply drag a RadTreeView onto the ShellLayoutView.cs form. Inside the code-behind, add a property to the RadTreeView so you can access ...
    May 27, 2021 3 min read
  • Productivity

    The Telerik CAB Enabling Kit and SCSF - Tutorial 5: The RadPanelBar UIExtensionSite

    Welcome to the fifth tutorial in my series of tutorials about the Telerik CAB Enabling Kit. This week, we will learn how to use the RadPanelBar UIExtensionSite. I will be using a TCEK enabled smart client application as the base for this tutorial. I’ve also created a simple module called the Asset Manager module that I will use in this tutorial. The Asset Manager Module The asset manager module is a basic CAB module that contains one view, the AssetListing view. The AssetListing view contains a RadGridView bound to a list of asset business objects. The business object, called “Asset”, contains ...
    May 27, 2021 3 min read
  • Productivity

    Altering OQL queries to generate different JOIN clauses in SQL

    As most of you probably know, OQL was the main object-oriented query language that was supported by Telerik OpenAcess ORM before Linq was introduced in .NET. Even though Linq is now the de facto standard for querying data, support for OQL is still there and I would state that it still is pretty convenient to use in some scenarios. We will use this post to share some tips on querying data using the Object Query Language. Consider the following query: IQueryResult projection = scope.GetOqlQuery("SELECT pr.ProductName, cat.CategoryName " + "FROM CategoryExtent AS cat,cat.Products AS pr").Execute();  This query makes...
    May 27, 2021 2 min read