OpenAccess ORm connection to database

Question

I'm new at Telerik & exploring as an option for ORM. I'm trying to do simple thing like writing a record to database using:

Database db = Database.Get("MyConnectionNameIUsedToGenerateClasses");
IObjectScope scope = db.GetObjectScope();
scope.Transaction.Begin();
LookUpType l = new LookUpType();
l.IsActive = true;
l.Name = "test";
scope.Add(l);
scope.Transaction.Commit();

It throws following error: The connection section with id 'MyConnectionNameIUsedToGenerateClasses' cannot be found in the configuration files traversed from '(OpenAccess internally generated. Is there anything I'm missing from the setup? Telerik did add connectionString to my web.config file with it generated classes. Please help. Thanks.

Answer 1

OpenAccess ORM should know of all the assemblies used by the application. The assemblies should be listed under the reference section within the configuration file:

• Open the web.config file in the web application project;
• Locate the references node;
• Alter the references node so that it gets the following form:

<references>
     <reference assemblyname="AssemblyName" configrequired="True" />
</references>

The configuration file format is described here.

Answer 2

As I mentioned in the comments above following code works & does my job:

Telerik.OpenAccess.Data.Common.OAConnection dbConnection = dbContext.Connection;
LookUpType l = new LookUpType();
l.IsActive = true;
l.Name = "test123";

LookUpType lkup = new LookUpType();
lkup.IsActive = true;
lkup.Name = "someTest";

dbContext.Add(new LookUpType[] { l, lkup });
dbContext.SaveChanges();