Is it possible to change the default behaviour of OpenAccess mapping?

[Chau Cheng]

What I am saying is, when doing forward mapping, I want :

1. System.String automatically map to NVARCHAR, 

2. The DB Table  Name and Column Name automatically use my Class Name and Property Name (not the private field name).

Going the mapping designer UI to tweak everything manually is a bit tedious for huge schema.

[PetarP]

Hello Chau Cheng,

 1. You can set the type mapping from the Backend configuration settings wizard. Navigate to Telerik -> OpenAccess -> Configuration->Backend configuration settings. At the bottom of the pop up window you will see a CLR Type Mapping setting. Click on the Collection and open the mapping screen. Set NVARCHAR for the SQL type of the System.String CLR type. Clicking ok will result in adding the following node to your app.config file:

<backendconfigurations>
      <backendconfiguration id="mssqlConfiguration" backend="mssql">
        <mappingname>mssqlMapping</mappingname>
        <logging.logEvents>none</logging.logEvents>
        <typeMap>
          <typeMapping>
            <CLRType>System.String</CLRType>
            <SQLType>nvarchar</SQLType>
          </typeMapping>
        </typeMap>
      </backendconfiguration>
    </backendconfigurations>

2. Unfortunately this is not yet possible with Telerik OpenAccess ORM. The only workaround would be to manually rename your column names. We are terribly sorry for any inconvenience this might have caused.

All the best,
Petar
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.