• .NET

    Check out all the new technologies you can use with OpenAccess ORM Q2 2012

    Q2 2012 of Telerik OpenAccess ORM is about to be released soon and we are eager to share what we have achieved for the last few months. As we always strive to keep up with the latest technologies available, we will start by presenting the support for: Visual Studio 11 Beta OpenAccess is compatible with the beta version of the new Visual Studio since the end of March - an internal build from March 29th is available even now. However, Q2 will be the first official release with a full functional support. MS SQL Server 2012 LocalDB As the commercial editions of SQL Server 2012 are...
  • .NET

    Telerik OpenAccess ORM - Using SQL Server 2012 LocalDB

    Microsoft SQL Server 2012 is certainly an interesting upgrade for the SQL Server, offering lots of improvements and new features. There are many things that might tempt you to migrate to 2012 or at least to start your new projects based on it, but to name a few: Enhancements for higher availability New and improved version of the SQL Server Management Studio Easier migration – the new Side-by-Side Migration option makes the migration from older versions of SQL Server safer and the rollback easier, which can be crucial. In the same time, you can do even an In Place migration (only if...
  • .NET

    Telerik OpenAccess ORM – Default Values support has arrived

    As many of you already know, we are offering you a chance to choose which features of OpenAccess ORM you would like to see implemented in the next releases. You can post your votes and comments in our PITS system, plus you can ask us to put new features there through the support system or forums. Recently there is one clear winner in PITS – the database default values support. It has been requested many times through our support system as well – and we would like to thank all of you for the feedback, we do appreciate it. We are glad...
  • .NET

    Bend Telerik OpenAccess ORM to Your Will with Type Converters – Storing Classes to XML

    In a previous blog I showed how to customize Telerik OpenAccess ORM data mappings using custom TypeConverters.  In particular we looked at storing, and querying, an enum by its name rather than its int value.  In this example, I will show how to get OpenAccess to serialize a class to xml, and store it in the database.  In the end you will have a reusable TypeConverter you can use to store any class as XML using OpenAccess! :) Creating the Type Converter The first thing we need to do is create the type converter.  To do that, simply grab the basic skeleton I displayed...
  • .NET

    String Matching in LINQ

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