Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns. Which options does OpenAccess and LINQ provide to perform string matching? Into which SQL is the LINQ expression translated?
Let’s use a simple class model for this post: a Person with a FirstName, a LastName and a NickName. Let’s assume parameters with the name simpleParam (string) and manyParam (ICollection<string>). String equality comparison Using the standard Equals method translates directly into...
With the Q3 2011 release of Telerik OpenAccess ORM we introduced three connection pool types which are explained in this blog post. In this blog post we will have a look at the connection pooling behavior of the Oracle driver and what setting to be used when we want to use Telerik OpenAccess ORM with Oracle databases. Which setting for Oracle and why? When we want to use Oracle as our backend, it is advisable to use the connection pool type Open Access Connection Pool with OpenAccess Connection Management or the Ado Connection Pool setting. When using one of the two settings, we...
With the Q3 2011 release of Telerik OpenAccess ORM we introduced three connection pool type settings. The OpenAccess Connection Pool, OpenAccess Connection Pool with OpenAccess Connection Management and the ADO Connection Pool. This blog post will show how these types can be used and when it makes sense to make use of them. OpenAccess Connection Pool With the type set to OpenAccess Connection pool, Telerik OpenAccess ORM will handle the connection pooling internally. Therefore a set of ADO connections is created that are maintained by the product. All settings for the connection pooling behavior can be configured via the settings dialog or...
We are very happy to announce the availability of Service Pack 2 for Telerik OpenAccess ORM. After a month of hard work we managed to address many of the reported problems and to deliver lots of major enhancements. You can find a detailed list of the fixes, by following this link. Download the new bits from your client accounts and let us know your feedback.
In order to provide a better usability with the 2010 Q1 release we introduced the new Visual Designer for Telerik Open Access ORM. We have been focusing on what we can do to improve your experience using OpenAccess. We have also introduced the new Context replacing the Object Scopes and various types of mappings used to define our model (currently only in reverse mapping scenarios). This being a major change we felt we needed to revise our Code Library assets and show you how to use OpenAccess to its full potential. Below is a list of the revised examples : ·...