Latest Online Resources for Telerik OpenAccess ORM

Thread is closed for posting
63 posts, 0 answers
  1. Telerik Admin
    Telerik Admin avatar
    1679 posts
    Member since:
    Oct 2004

    Posted 22 Nov 2012 Link to this post

    Handling Error: Invalid object name 'voa_keygen' in runtime 
    A Knowledge Base article that helps you overcome the above-mentioned runtime error - in most cases due to a missing Identity field in some of your Domain Classes.
  2. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 30 Nov 2012 Link to this post

    Manually Installing References Required by the Web API Service
    A Knowledge Base article describing how to generate an ASP.NET Web API service on machines that have internet connection problems and the Web API Nuget installation invoked by the Add OpenAccess Service wizard has failed.
  3. DevCraft banner
  4. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 06 Dec 2012 Link to this post

    Handling the Warning: "Explicit change tracking required for the array field …"
    This Knowledge Base article shows how to explicitly inform OpenAccess ORM about changes in array fields, which cannot be tracked automatically.
  5. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 13 Dec 2012 Link to this post

    How to: Generate a Web API Service From Classes with a Composite Primary Key
    This Knowledge Base article is a thorough guide for customizing your Web API services if you have Domain Classes with a composite primary key. It includes a code sample which will help you create the appropriate repositories for such classes in both C# and Visual Basic.

    Handling the "Could not load file or assembly Telerik.OpenAccess..." Exception
    This forum thread contains instructions for resolving your issues in case you have encountered the described exception. 
  6. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 19 Dec 2012 Link to this post

    Map Multi-Table Entities with OpenAccess ORM Q3'12 SP1
    In this blog post we make a short review of the latest improvements released in Q3 2012 SP1 of OpenAccess ORM, and also describe the most interesting new feature - support for mapping several tables to one class using Fluent API. You can see the new functionality in action based on a typical usage scenario.
  7. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 07 Jan 2013 Link to this post

    Handling Error: No metadata registered for class
    In this Knowledge Base article we are presenting different approaches for analyzing and handling the above-mentioned exception, which is typically thrown when your projects are not properly enhanced during their build process by the OpenAccess Enhancer tool.
  8. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 10 Jan 2013 Link to this post

    How to: Retrieve paged data from a WebAPI service generated by the AOS wizard
    In this Code Library sample we are showing how you can extend the ASP.NET Web API services that the Add OpenAccess Service wizard is generating so that you can achieve optimal paging of the results.

    Data Annotations in MVC applications
    In this forum post we are presenting how you can enhance your OpenAccess Domain Classes in order to make use of the data annotation attributes that ASP.NET MVC is using for validation purposes.
  9. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 21 Jan 2013 Link to this post

    Pre-Filtering Data
    In this forum thread you can find guidance on how to filter the IQueryable collections of your context before your client code accesses them. The recommended approach is applicable for cases such as limiting the access of certain users to some records or other similar scenarios.

    Telerik OpenAccess ORM - Your Feedback Does Matter
    As we are continuously improving OpenAccess ORM based on your requests, we decided to move to an even better platform for gathering your feedback than the PITS system - The Ideas & Feedback portal by TeamPulse. In this blog post you can find some details about it.
  10. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 25 Jan 2013 Link to this post

    How to: Shape a Return Type of a LINQ Statement
    In this Code Library sample we are presenting you how to use anonymous types and result sets returned from LINQ statements in your applications, including binding them to a ASP.NET AJAX RadGrid.
  11. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 31 Jan 2013 Link to this post

    How to: Persist the Changes Made by a Stored Procedure to The Database
    This Knowledge Base article describes how to apply in the database the changes performed by an insert, update or delete stored procedure. I also includes a brief demonstration of the approaches OpenAccess offers regarding how to call a stored procedure in your code.
  12. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 07 Feb 2013 Link to this post

    How to: Insert Related Objects in the Database
    This knowledge base article addresses a task common for all developers that use an ORM - the insertion of related objects in the database. It demonstrates the approaches offered by OpenAccess and their implementation.
  13. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 18 Feb 2013 Link to this post

    Get ready for the goodness inside Telerik OpenAccess ORM Q1'13
    We are releasing Q1 2013 within days and many of you have already asked what’s coming with Telerik OpenAccess ORM? That's why we've decided to shed some light on how the new version will help you achieve your goals even quicker than the previous ones.
  14. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 25 Feb 2013 Link to this post

    Highlights

    Splitting Into Multiple Diagrams
    This section describes a new feature of OpenAccess that allows the users to develop the conceptual part of their domain model in more than one visual diagram. It is implemented in OpenAccess Visual Designer and could be extremely useful in cases of large models that are logically separated in several database schemas or namespaces. The section contains two articles that explain how to use multiple diagrams with newly created domain models and with existing ones.

    Working with Streams
    This documentation article describes the workflow with the new OpenAccess Streaming API. This special API is capable of working with binary large objects and implements the Telerik.OpenAccess.BinaryStream type that exposes a stream around a database binary field.

    Artificial Types CRUD Operations
    This set of articles demonstrates how to perform CRUD operations with artificial types at runtime. The section consists of four separate topics which provide step-by-step guidance and code snippets describing the processes of inserting, updating, deleting and selecting artificial types.

    Dynamic Data Wizard: Configure Context Endpoints Dialog
    This documentation article shows how to setup the Configure Context Endpoints dialog of the Dynamic Data wizard. It demonstrates the new Use RadControls for Ajax feature that allows you to create the custom data pages with the help of Telerik RadControls for ASP.NET AJAX if they are installed on your machine.

    Code Generation: Fluent Mapping

    This documentation article provides guidelines about the creation of a domain model that utilizes the Fluent Mapping API of OpenAccess. Here the developers can find how to use the enhanced Telerik OpenAccess Fluent Library project template and the Telerik OpenAccess Fluent Model item template. The article also includes a step-by-step workflow showing the process of migration from XML/Attributes mapping type to Fluent. Except that, the article gives information about the limitations of the Fluent mapping type.


    Other New Resources
     
    Split Entities During the Model Generation
    This documentation article offers a practical how-to that demonstrates the process of creating a domain model utilizing the Database First approach and the new feature of OpenAccess for creating a separate diagram for each schema in the database.

    Splitting Entities in the Visual Designer
    This documentation article explains to the developers how to crate a new diagram inside an existing domain model and how to copy/move the domain classes between the different diagrams. It also guides the users through the process of renaming the created diagrams.

    Inserting Artificial Types
    This article shows how to create new instances of artificial types and how to initialize them. It demonstrates the usage of the CreateInstance and CreateDynamicInstance extension methods of OpenAccessContext.

    Querying Artificial Types
    This article describes how to retrieve artificial types from the database. It demonstrates the usage of the GetAll and FieldValue<T> extension methods.

    Updating Artificial Types
    This article demonstrates how to update artificial types in the database. It shows the usage of the SetFieldValue<T> extension method.

    Delete Artificial Types
    This article demonstrates how to delete artificial types from the database. It shows the usage of the Delete and SaveChanges methods of OpenAccessContext.

    Code Only Mapping: How to: Create a Fluent Mapping Library
    This documentation article describes how to get started with the usage of the Fluent - Mapping API of OpenAccess. It demonstrates the new OpenAccess New Fluent Model wizard that helps you with the initial effort when you generate a fluent domain model from an existing database. It also shows how to utilize the OpenAccess ORM NuGet Packages for code first development.
  15. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 05 Mar 2013 Link to this post

    How to simplify work with large models using OpenAccess ORM
    As we believe that ease of implementation is essential for all OpenAccess users, this blog aims to show you how you can save even more time with the features packed in the recently released Q1 2013 version.
  16. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 11 Mar 2013 Link to this post

    How to: Manipulate Data With Stored Procedures
    This documentation article demonstrates an important detail regarding a common development scenario - adding, updating or deleting data with the help of stored procedures and OpenAccess ORM.

    MariaDB
    Since Q1 2013 OpenAccess ORM supports the MariaDB relational database management system.
  17. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 18 Mar 2013 Link to this post

    How to: Create Constraints in Model - First Scenario
    This knowledge base article describes how to ensure that constraints are generated based on the domain model associations and how to persist them in the database.
  18. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 25 Mar 2013 Link to this post

    Managing OpenAccessContext in Web Applications
    One of the most challenging tasks when you develop a web application with OpenAccess ORM is to handle correctly the context. The three articles in this documentation section are enhanced to show the three most preferable ways to manage the lifecycle of OpenAccessContext.

    Samples Kit
    OpenAccess Samples Kit is an offline resource browser that offers a set of samples that demonstrate a variety of real life scenarios accomplished on both C# and VB, using a wide range of .NET technologies and with different levels of complexity. This set of documentation articles will guide you through your first steps with this tool.
  19. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 26 Mar 2013 Link to this post

    Upgrading OpenAccess ORM to Q1 2013: Restore Custom Diagram Layout
    In Q1 2013, OpenAccess ORM released the Multi-Diagrams feature that introduced a new format of the .diagram file that holds the information about the visual representation of the domain model's diagram in Visual Designer. This knowledge base article describes a workflow that will help you restore the layout for an existing domain model to its state prior an upgrade to OpenAccess ORM Q1 2013.

    How to: Perform Safe Delete Without Foreign Key Constraints
    There are scenarios when for a variety of reasons the developers prefer to set database relationships without enforcing foreign key constrains or not create relationships at all. In such cases the integrity of the data stored in the database might be disrupted due to a delete operation. This knowledge base article offers a solution how such a scenario can be handled with OpenAccess.
  20. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 04 Apr 2013 Link to this post

    Using Encrypted Connection Strings with OpenAccess ORM
    This article demonstrates how you can use encrypted connection strings with Telerik OpenAccess ORM within your web applications.
  21. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 12 Apr 2013 Link to this post

    Telerik OpenAccess ORM - Web Services Overview
    This video will demonstrate the wizards that would help you with the generation of a wide variety of web services in OpenAccess ORM. In it you can get a quick overview of the entry points of the wizards and the types of services they generate.  
  22. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 19 Apr 2013 Link to this post

    Kick-start your implementation using OpenAccess Samples Kit
    Samples Kit is an offline application which offers you dozens of examples. In each of them OpenAccess ORM is used in a different scenario, and with different technologies, including ASP.NET, WPF, HTML5, Web Services, LINQ, etc. It is the place to start in case you want to validate how OpenAccess ORM fits into your solution. Each of the applications comes with a database that it automatically created/attached and configured so that you can just run any project with a few clicks!
  23. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 26 Apr 2013 Link to this post

    Expose your data through ASP.NET Web API
    In this video you will see how to expose your data using ASP.NET Web API and and to consume it through KendoUI controls with minimal effort. The data access layer on the server side is implemented with Telerik OpenAccess ORM and the Add OpenAccess Service wizard is used in order to automatically generate the needed service.
  24. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 02 May 2013 Link to this post

    Simplify all CRUD operations with OpenAccess ORM
    This video will present you the basics of using Telerik OpenAccess ORM for the Create, Retrieve, Update and Delete operations in your application.

    Telerik OpenAccess ORM in action
    Telerik OpenAccess Samples Kit speaks louder than words! Take a look at 50+ real-life scenarios of using OpenAccess ORM, new ones added with each following Q release.
  25. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 16 May 2013 Link to this post

    Package Installation Error: Could not add all required packages to the project
    This knowledge base article will help you to resolve an error thrown by Visual Studio 2012 Update 2 when you attempt to create a project with the OpenAccess web templates distributed with version Q1 2013 SP1 or earlier.
  26. Ivailo
    Admin
    Ivailo avatar
    318 posts

    Posted 27 May 2013 Link to this post

    Generate Methods for your Stored Procedures and Functions
    Don't bother fighting with stored procedures and functions written in SQL - wrap them as .NET methods using the OpenAccess Domain Method Editor. It will generate code for you based on the result set of a stored procedure or function. The functions can even be used in LINQ statements for a more powerful query execution.
  27. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 04 Jun 2013 Link to this post

    Data Annotation attributes in seconds
    Find out about one of the cool new features that will be offered by Q2 2013 of Telerik OpenAccess ORM - automatic generation of Data Annotation attributes.
  28. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 10 Jun 2013 Link to this post

    Data Annotation attributes in seconds
    Find out about one of the cool new features that will be offered by Q2 2013 of Telerik OpenAccess ORM - automatic generation of Data Annotation attributes.

    INotifyPropertyChanged out of the box
    INotifyPropertyChanged and INotifyPropertyChanging interface implementations for all persistent properties will be only one click away with Q2 2013 of OpenAccess ORM!
  29. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 21 Jun 2013 Link to this post

    Data Validation with IDataErrorInfo
    Add an implementation of IDataErrorInfo to your entities with a single checkbox! Use the interface to communicate the data validation results to the UI controls with minimum efforts.

    Bulk Operations
    Minimize the client side resources your application uses with OpenAccess Bulk Operations. The DeleteAll() and UpdateAll() methods allow you to manipulate large amounts of data on the server side in either a single call to the database or in batches.

    Handling Model Changes
    The Update Database from Model wizard currently allows you to mark for removal database tables that are not mapped in your model and generates the appropriate DDL script for dropping them. That way the storage model can always be synchronized with the domain model.

    Code Generation Options
    Find out how to enhance the domain entities in your model with DataAnnotation attributes, implementation of INotifyPropertyChanging/ed and implementation of IDataErrorInfo
  30. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 25 Jun 2013 Link to this post

    How to: Bulk Delete Artificial Types
    In Q2 2013 OpenAccess ORM introduced the support of server-side bulk operations. This article will provide you with both examples and details about the usage of the DeleteAll() method on artificial types.

    How to: Bulk Update Artificial Types
    One of the bulk operations supported by OpenAccess ORM is server-side update. It is performed with the help of the UpdateAll() method and this article will demonstrate to you how you can use it for artificial types.
  31. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 25 Jun 2013 Link to this post

    Bulk Update and Delete as easy as LINQ
    Telerik OpenAccess ORM Q2 2013 delivers one of the most requested features from many ORM frameworks. The new Bulk Operations LINQ-like API allows you to update or delete thousands of records with a single call, posting a server side SQL statement.
Back to Top
DevCraft banner