Productivity

The references in the object model and the references in the database schema can be defined in several ways. The definitions are following different idioms and it is not straight forward how a mapping can be defined. In the database schema you have the foreign key reference; in the object model you have single references, collections and dictionaries. Let’s look at a simple schema in the database, the Persons table has a foreign key reference to the Addresses table. There are now 3 ways to map this in OpenAccess. 1. You can map it to a reference field which is the...

Continuing with the LINQ tips, today we provide a list of System.Math methods that we are going to support with the upcoming Q3 release. The following table shows the supported methods; when no indication is given, all the overloaded (double,decimal,...) versions will work. Abs Min Max Acos, Asin, Atan, Atan2 Cos,Sin,Tan Cosh, Sinh, Tanh Sqrt Power Trunc Exp Log(double) Log10 Ceil Floor Round (*) Sign   (*) Only the Round(double) and Round(x,y) methods where y!=MidpointRounding are supported.   That means, you can push now many more calculations to the database server. Be aware however, that using the database server engine might produce different results than would be calculated when the CLR is used; e.g....

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...

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...

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 ...