This question is locked. New answers and comments are not allowed.
I add a table in my database
Schema
Field 1 = ID primary Key with identity
Field 2 = Name Varchar(80)
I apply reverse mapping and merge
when generate and save I see this error
The following problem(s) have occurred :
1. startIndex cannot be larger than length of string.
Parameter name: startIndex
Please try again after fixing the problem.
Please help
Thanks in advance
NOTE: The settings made so far have been saved to the reversemapping.config file.
Schema
Field 1 = ID primary Key with identity
Field 2 = Name Varchar(80)
I apply reverse mapping and merge
when generate and save I see this error
The following problem(s) have occurred :
1. startIndex cannot be larger than length of string.
Parameter name: startIndex
Please try again after fixing the problem.
Please help
Thanks in advance
NOTE: The settings made so far have been saved to the reversemapping.config file.
9 Answers, 1 is accepted
0
Hi juance,
I tried the merge functionality with the changes you mentioned and it worked fine for me. I could generate the new class without any error.
Can you please send me the reversemapping.config file so that I can try and reproduce the error here?
Kind regards,
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
I tried the merge functionality with the changes you mentioned and it worked fine for me. I could generate the new class without any error.
Can you please send me the reversemapping.config file so that I can try and reproduce the error here?
Kind regards,
Ady
the Telerik team
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
0
juance
Top achievements
Rank 1
answered on 08 Apr 2009, 11:01 AM
I am using vs2008 team system, sql express 2005 and windows xp sp3
Here the reverse mapping
<?xml version="1.0" encoding="UTF-8"?>
<openaccess>
<classGenerator defaultPackageName="ClassLibrary1">
<table name="'Categories'" type="1" locked="False">
<column name="CategoryID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CategoryName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="False" />
<column name="Description" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="Picture" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<index name="CategoryName" unique="False" clustered="False">
<column name="CategoryName" />
</index>
<class name="Category" check="-1" generated="True">
<field name="_categoryID" type="1" isPK="True" isAutoInc="True" column="CategoryID" valueType="System.Int32" />
<field name="_categoryName" type="1" isPK="False" column="CategoryName" valueType="System.String" />
<field name="_description" type="1" isPK="False" column="Description" valueType="System.String" />
<field name="_picture" type="1" isPK="False" column="Picture" valueType="System.Byte[]" />
</class>
</table>
<table name="'CustomerCustomerDemo'" type="2" locked="False">
<column name="CustomerID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="False" />
<column name="CustomerTypeID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="10" isNull="False" />
<constraint name="FK_CustomerCustomerDemo" table="'CustomerCustomerDemo'" dest="'CustomerDemographics'">
<column name="CustomerTypeID" />
</constraint>
<constraint name="FK_CustomerCustomerDemo_Customers" table="'CustomerCustomerDemo'" dest="'Customers'">
<column name="CustomerID" />
</constraint>
<field name="_customerCustomerDemo" type="4" owner="'CustomerDemographics'" reference="'Customers'">
<mapping field="CustomerDemographic._customerTypeID (Owner)" column="CustomerTypeID" />
<mapping field="Customer._customerID (Value)" column="CustomerID" />
</field>
</table>
<table name="'CustomerDemographics'" type="1" locked="False">
<column name="CustomerTypeID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="10" isNull="False" />
<column name="CustomerDesc" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<class name="CustomerDemographic" check="-1" generated="True">
<field name="_customerTypeID" type="1" isPK="True" column="CustomerTypeID" valueType="System.String" />
<field name="_customerDesc" type="1" isPK="False" column="CustomerDesc" valueType="System.String" />
</class>
</table>
<table name="'Customers'" type="1" locked="False">
<column name="CustomerID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="ContactName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="ContactTitle" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Fax" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Bool" isPk="False" isAutoInc="False" adoType="-7" sqlType="bit" length="0" isNull="True" />
<index name="City" unique="False" clustered="False">
<column name="City" />
</index>
<index name="CompanyName" unique="False" clustered="False">
<column name="CompanyName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<index name="Region" unique="False" clustered="False">
<column name="Region" />
</index>
<class name="Customer" check="-1" generated="True">
<field name="_customerID" type="1" isPK="True" column="CustomerID" valueType="System.String" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_bool1" type="1" isPK="False" column="Bool" valueType="System.Nullable`1[[System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_contactName" type="1" isPK="False" column="ContactName" valueType="System.String" />
<field name="_contactTitle" type="1" isPK="False" column="ContactTitle" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_fax" type="1" isPK="False" column="Fax" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
</class>
</table>
<table name="'EmployeeTerritories'" type="2" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="TerritoryID" isPk="True" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<constraint name="FK_EmployeeTerritories_Employees" table="'EmployeeTerritories'" dest="'Employees'">
<column name="EmployeeID" />
</constraint>
<constraint name="FK_EmployeeTerritories_Territories" table="'EmployeeTerritories'" dest="'Territories'">
<column name="TerritoryID" />
</constraint>
<field name="_employeeTerritories" type="4" owner="'Employees'" reference="'Territories'">
<mapping field="Employee._employeeID (Owner)" column="EmployeeID" />
<mapping field="Territory._territoryID (Value)" column="TerritoryID" />
</field>
</table>
<table name="'Employees'" type="1" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="LastName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="FirstName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="TitleOfCourtesy" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="25" isNull="True" />
<column name="BirthDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="HireDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="HomePhone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Extension" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="4" isNull="True" />
<column name="Photo" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<column name="Notes" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="ReportsTo" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="PhotoPath" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="255" isNull="True" />
<constraint name="FK_Employees_Employees" table="'Employees'" dest="'Employees'">
<column name="ReportsTo" />
</constraint>
<index name="LastName" unique="False" clustered="False">
<column name="LastName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<class name="Employee" check="-1" generated="True">
<field name="_employeeID" type="1" isPK="True" isAutoInc="True" column="EmployeeID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_birthDate" type="1" isPK="False" column="BirthDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_extension" type="1" isPK="False" column="Extension" valueType="System.String" />
<field name="_firstName" type="1" isPK="False" column="FirstName" valueType="System.String" />
<field name="_hireDate" type="1" isPK="False" column="HireDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_homePhone" type="1" isPK="False" column="HomePhone" valueType="System.String" />
<field name="_lastName" type="1" isPK="False" column="LastName" valueType="System.String" />
<field name="_notes" type="1" isPK="False" column="Notes" valueType="System.String" />
<field name="_photo" type="1" isPK="False" column="Photo" valueType="System.Byte[]" />
<field name="_photoPath" type="1" isPK="False" column="PhotoPath" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
<field name="_reportsTo" type="1" isPK="False" column="ReportsTo" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_titleOfCourtesy" type="1" isPK="False" column="TitleOfCourtesy" valueType="System.String" />
<field name="_employee" type="2" isPK="False" reference="'Employees'">
<mapping field="Employee._employeeID" column="ReportsTo" />
</field>
</class>
</table>
<table name="'LargeEmployees'" type="1" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="LastName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="FirstName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="TitleOfCourtesy" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="25" isNull="True" />
<column name="BirthDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="HireDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="HomePhone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Extension" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="4" isNull="True" />
<column name="Photo" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<column name="Notes" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="ReportsTo" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="PhotoPath" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="255" isNull="True" />
<class name="LargeEmployee" check="-1" generated="True">
<field name="_employeeID" type="1" isPK="True" isAutoInc="True" column="EmployeeID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_birthDate" type="1" isPK="False" column="BirthDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_extension" type="1" isPK="False" column="Extension" valueType="System.String" />
<field name="_firstName" type="1" isPK="False" column="FirstName" valueType="System.String" />
<field name="_hireDate" type="1" isPK="False" column="HireDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_homePhone" type="1" isPK="False" column="HomePhone" valueType="System.String" />
<field name="_lastName" type="1" isPK="False" column="LastName" valueType="System.String" />
<field name="_notes" type="1" isPK="False" column="Notes" valueType="System.String" />
<field name="_photo" type="1" isPK="False" column="Photo" valueType="System.Byte[]" />
<field name="_photoPath" type="1" isPK="False" column="PhotoPath" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
<field name="_reportsTo" type="1" isPK="False" column="ReportsTo" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_titleOfCourtesy" type="1" isPK="False" column="TitleOfCourtesy" valueType="System.String" />
</class>
</table>
<table name="'Messages'" type="1" locked="False">
<column name="MessageId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Text" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="False" />
<column name="Date" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="Sender" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="Receiver" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="RadProductId" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="UserId" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_Messages_RadProducts" table="'Messages'" dest="'RadProducts'">
<column name="RadProductId" />
</constraint>
<constraint name="FK_Messages_Users" table="'Messages'" dest="'Users'">
<column name="UserId" />
</constraint>
<class name="Message" check="-1" generated="True">
<field name="_messageId" type="1" isPK="True" isAutoInc="True" column="MessageId" valueType="System.Int32" />
<field name="_date1" type="1" isPK="False" column="Date" valueType="System.DateTime" />
<field name="_radProductId" type="1" isPK="False" column="RadProductId" valueType="System.Int32" />
<field name="_receiver" type="1" isPK="False" column="Receiver" valueType="System.String" />
<field name="_sender" type="1" isPK="False" column="Sender" valueType="System.String" />
<field name="_text" type="1" isPK="False" column="Text" valueType="System.String" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_userId" type="1" isPK="False" column="UserId" valueType="System.Int32" />
<field name="_radProduct" type="2" isPK="False" reference="'RadProducts'">
<mapping field="RadProduct._radProductId" column="RadProductId" />
</field>
<field name="_user" type="2" isPK="False" reference="'Users'">
<mapping field="User._userId" column="UserId" />
</field>
</class>
</table>
<table name="'Order Details'" type="1" locked="False">
<column name="OrderID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="ProductID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="UnitPrice" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="5" isNull="False" />
<column name="Quantity" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="False" />
<column name="Discount" isPk="False" isAutoInc="False" adoType="7" sqlType="real" length="4" isNull="False" />
<constraint name="FK_Order_Details_Orders" table="'Order Details'" dest="'Orders'">
<column name="OrderID" />
</constraint>
<constraint name="FK_Order_Details_Products" table="'Order Details'" dest="'Products'">
<column name="ProductID" />
</constraint>
<index name="OrderID" unique="False" clustered="False">
<column name="OrderID" />
</index>
<index name="ProductID" unique="False" clustered="False">
<column name="ProductID" />
</index>
<class name="OrderDetail" check="-1" generated="True">
<field name="_orderID" type="1" isPK="True" column="OrderID" valueType="System.Int32" />
<field name="_productID" type="1" isPK="True" column="ProductID" valueType="System.Int32" />
<field name="_discount" type="1" isPK="False" column="Discount" valueType="System.Single" />
<field name="_quantity" type="1" isPK="False" column="Quantity" valueType="System.Int16" />
<field name="_unitPrice" type="1" isPK="False" column="UnitPrice" valueType="System.Decimal" />
<field name="_order" type="2" isPK="False" reference="'Orders'">
<mapping field="Order._orderID" column="OrderID" />
</field>
<field name="_product" type="2" isPK="False" reference="'Products'">
<mapping field="Product._productID" column="ProductID" />
</field>
</class>
</table>
<table name="'Orders'" type="1" locked="False">
<column name="OrderID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CustomerID" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="True" />
<column name="EmployeeID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="OrderDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="RequiredDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="ShippedDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="ShipVia" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="Freight" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="6" isNull="True" />
<column name="ShipName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="True" />
<column name="ShipAddress" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="ShipCity" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="ShipRegion" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="ShipPostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="ShipCountry" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<constraint name="FK_Orders_Customers" table="'Orders'" dest="'Customers'">
<column name="CustomerID" />
</constraint>
<constraint name="FK_Orders_Employees" table="'Orders'" dest="'Employees'">
<column name="EmployeeID" />
</constraint>
<constraint name="FK_Orders_Shippers" table="'Orders'" dest="'Shippers'">
<column name="ShipVia" />
</constraint>
<index name="CustomerID" unique="False" clustered="False">
<column name="CustomerID" />
</index>
<index name="EmployeeID" unique="False" clustered="False">
<column name="EmployeeID" />
</index>
<index name="OrderDate" unique="False" clustered="False">
<column name="OrderDate" />
</index>
<index name="ShippedDate" unique="False" clustered="False">
<column name="ShippedDate" />
</index>
<index name="ShippersOrders" unique="False" clustered="False">
<column name="ShipVia" />
</index>
<index name="ShipPostalCode" unique="False" clustered="False">
<column name="ShipPostalCode" />
</index>
<class name="Order" check="-1" generated="True">
<field name="_orderID" type="1" isPK="True" isAutoInc="True" column="OrderID" valueType="System.Int32" />
<field name="_customerID" type="1" isPK="False" column="CustomerID" valueType="System.String" />
<field name="_employeeID" type="1" isPK="False" column="EmployeeID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_freight" type="1" isPK="False" column="Freight" valueType="System.Nullable`1[[System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_orderDate" type="1" isPK="False" column="OrderDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_requiredDate" type="1" isPK="False" column="RequiredDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_shipAddress" type="1" isPK="False" column="ShipAddress" valueType="System.String" />
<field name="_shipCity" type="1" isPK="False" column="ShipCity" valueType="System.String" />
<field name="_shipCountry" type="1" isPK="False" column="ShipCountry" valueType="System.String" />
<field name="_shipName" type="1" isPK="False" column="ShipName" valueType="System.String" />
<field name="_shipPostalCode" type="1" isPK="False" column="ShipPostalCode" valueType="System.String" />
<field name="_shipRegion" type="1" isPK="False" column="ShipRegion" valueType="System.String" />
<field name="_shipVia" type="1" isPK="False" column="ShipVia" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_shippedDate" type="1" isPK="False" column="ShippedDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_customer" type="2" isPK="False" reference="'Customers'">
<mapping field="Customer._customerID" column="CustomerID" />
</field>
<field name="_employee" type="2" isPK="False" reference="'Employees'">
<mapping field="Employee._employeeID" column="EmployeeID" />
</field>
<field name="_shipper" type="2" isPK="False" reference="'Shippers'">
<mapping field="Shipper._shipperID" column="ShipVia" />
</field>
</class>
</table>
<table name="'Products'" type="1" locked="False">
<column name="ProductID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="ProductName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="SupplierID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="CategoryID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="QuantityPerUnit" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="True" />
<column name="UnitPrice" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="5" isNull="True" />
<column name="UnitsInStock" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="UnitsOnOrder" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="ReorderLevel" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="Discontinued" isPk="False" isAutoInc="False" adoType="-7" sqlType="bit" length="0" isNull="False" />
<column name="voa_class" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="pges" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<index name="CategoriesProducts" unique="False" clustered="False">
<column name="CategoryID" />
</index>
<class name="Product" check="-1" generated="True">
<field name="_productID" type="1" isPK="True" isAutoInc="True" column="ProductID" valueType="System.Int32" />
<field name="_categoryID" type="1" isPK="False" column="CategoryID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_classType" type="1" isPK="False" column="voa_class" valueType="System.Int32" />
<field name="_discontinued" type="1" isPK="False" column="Discontinued" valueType="System.Boolean" />
<field name="_pges" type="1" isPK="False" column="pges" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_productName" type="1" isPK="False" column="ProductName" valueType="System.String" />
<field name="_quantityPerUnit" type="1" isPK="False" column="QuantityPerUnit" valueType="System.String" />
<field name="_reorderLevel" type="1" isPK="False" column="ReorderLevel" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_supplierID" type="1" isPK="False" column="SupplierID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitPrice" type="1" isPK="False" column="UnitPrice" valueType="System.Nullable`1[[System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitsInStock" type="1" isPK="False" column="UnitsInStock" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitsOnOrder" type="1" isPK="False" column="UnitsOnOrder" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
</class>
</table>
<table name="'Prueba'" type="1" locked="False">
<column name="ID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Apellidos" isPk="False" isAutoInc="False" adoType="12" sqlType="varchar" length="30" isNull="True" />
<column name="Nombres" isPk="False" isAutoInc="False" adoType="12" sqlType="varchar" length="30" isNull="True" />
<column name="Fecha" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<class name="Prueba" check="-1" generated="True">
<field name="_id" type="1" isPK="True" isAutoInc="True" column="ID" valueType="System.Int32" />
<field name="_apellidos" type="1" isPK="False" column="Apellidos" valueType="System.String" />
<field name="_fecha" type="1" isPK="False" column="Fecha" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_nombres" type="1" isPK="False" column="Nombres" valueType="System.String" />
</class>
</table>
<table name="'RadProducts'" type="1" locked="False">
<column name="RadProductId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Name" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Description" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="200" isNull="True" />
<class name="RadProduct" check="-1" generated="True">
<field name="_radProductId" type="1" isPK="True" isAutoInc="True" column="RadProductId" valueType="System.Int32" />
<field name="_description" type="1" isPK="False" column="Description" valueType="System.String" />
<field name="_name" type="1" isPK="False" column="Name" valueType="System.String" />
</class>
</table>
<table name="'Region'" type="1" locked="False">
<column name="RegionID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RegionDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<class name="Region" check="-1" generated="True">
<field name="_regionID" type="1" isPK="True" column="RegionID" valueType="System.Int32" />
<field name="_regionDescription" type="1" isPK="False" column="RegionDescription" valueType="System.String" />
</class>
</table>
<table name="'Region_new'" type="1" locked="False">
<column name="RegionID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RegionDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<class name="RegionNew" check="-1" generated="True">
<field name="_regionID" type="1" isPK="True" column="RegionID" valueType="System.Int32" />
<field name="_regionDescription" type="1" isPK="False" column="RegionDescription" valueType="System.String" />
</class>
</table>
<table name="'Shippers'" type="1" locked="False">
<column name="ShipperID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<class name="Shipper" check="-1" generated="True">
<field name="_shipperID" type="1" isPK="True" isAutoInc="True" column="ShipperID" valueType="System.Int32" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
</class>
</table>
<table name="'Suppliers'" type="1" locked="False">
<column name="SupplierID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="ContactName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="ContactTitle" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Fax" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="HomePage" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<index name="CompanyName" unique="False" clustered="False">
<column name="CompanyName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<class name="Supplier" check="-1" generated="True">
<field name="_supplierID" type="1" isPK="True" isAutoInc="True" column="SupplierID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_contactName" type="1" isPK="False" column="ContactName" valueType="System.String" />
<field name="_contactTitle" type="1" isPK="False" column="ContactTitle" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_fax" type="1" isPK="False" column="Fax" valueType="System.String" />
<field name="_homePage" type="1" isPK="False" column="HomePage" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
</class>
</table>
<table name="'Territories'" type="1" locked="False">
<column name="TerritoryID" isPk="True" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="TerritoryDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<column name="RegionID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_Territories_Region" table="'Territories'" dest="'Region'">
<column name="RegionID" />
</constraint>
<class name="Territory" check="-1" generated="True">
<field name="_territoryID" type="1" isPK="True" column="TerritoryID" valueType="System.String" />
<field name="_regionID" type="1" isPK="False" column="RegionID" valueType="System.Int32" />
<field name="_territoryDescription" type="1" isPK="False" column="TerritoryDescription" valueType="System.String" />
<field name="_region" type="2" isPK="False" reference="'Region'">
<mapping field="Region._regionID" column="RegionID" />
</field>
</class>
</table>
<table name="'Users'" type="1" locked="False">
<column name="UserId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Name" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Email" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Image" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<class name="User" check="-1" generated="True">
<field name="_userId" type="1" isPK="True" isAutoInc="True" column="UserId" valueType="System.Int32" />
<field name="_email" type="1" isPK="False" column="Email" valueType="System.String" />
<field name="_image" type="1" isPK="False" column="Image" valueType="System.String" />
<field name="_name" type="1" isPK="False" column="Name" valueType="System.String" />
</class>
</table>
<table name="'UsersRadProducts'" type="2" locked="False">
<column name="UserId" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RadProductId" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_UsersRadProducts_RadProducts" table="'UsersRadProducts'" dest="'RadProducts'">
<column name="RadProductId" />
</constraint>
<constraint name="FK_UsersRadProducts_Users" table="'UsersRadProducts'" dest="'Users'">
<column name="UserId" />
</constraint>
<field name="_usersRadProducts" type="4" owner="'RadProducts'" reference="'Users'">
<mapping field="RadProduct._radProductId (Owner)" column="RadProductId" />
<mapping field="User._userId (Value)" column="UserId" />
</field>
</table>
</classGenerator>
<options>
<sourcegeneration partial="True" />
<allSchemata>
<schemata name="(default)" />
</allSchemata>
<usedSchemata>
<schemata name="(default)" />
</usedSchemata>
<mapping>
<identity explicitIDClass="False" />
</mapping>
</options>
</openaccess>
Here the reverse mapping
<?xml version="1.0" encoding="UTF-8"?>
<openaccess>
<classGenerator defaultPackageName="ClassLibrary1">
<table name="'Categories'" type="1" locked="False">
<column name="CategoryID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CategoryName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="False" />
<column name="Description" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="Picture" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<index name="CategoryName" unique="False" clustered="False">
<column name="CategoryName" />
</index>
<class name="Category" check="-1" generated="True">
<field name="_categoryID" type="1" isPK="True" isAutoInc="True" column="CategoryID" valueType="System.Int32" />
<field name="_categoryName" type="1" isPK="False" column="CategoryName" valueType="System.String" />
<field name="_description" type="1" isPK="False" column="Description" valueType="System.String" />
<field name="_picture" type="1" isPK="False" column="Picture" valueType="System.Byte[]" />
</class>
</table>
<table name="'CustomerCustomerDemo'" type="2" locked="False">
<column name="CustomerID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="False" />
<column name="CustomerTypeID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="10" isNull="False" />
<constraint name="FK_CustomerCustomerDemo" table="'CustomerCustomerDemo'" dest="'CustomerDemographics'">
<column name="CustomerTypeID" />
</constraint>
<constraint name="FK_CustomerCustomerDemo_Customers" table="'CustomerCustomerDemo'" dest="'Customers'">
<column name="CustomerID" />
</constraint>
<field name="_customerCustomerDemo" type="4" owner="'CustomerDemographics'" reference="'Customers'">
<mapping field="CustomerDemographic._customerTypeID (Owner)" column="CustomerTypeID" />
<mapping field="Customer._customerID (Value)" column="CustomerID" />
</field>
</table>
<table name="'CustomerDemographics'" type="1" locked="False">
<column name="CustomerTypeID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="10" isNull="False" />
<column name="CustomerDesc" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<class name="CustomerDemographic" check="-1" generated="True">
<field name="_customerTypeID" type="1" isPK="True" column="CustomerTypeID" valueType="System.String" />
<field name="_customerDesc" type="1" isPK="False" column="CustomerDesc" valueType="System.String" />
</class>
</table>
<table name="'Customers'" type="1" locked="False">
<column name="CustomerID" isPk="True" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="ContactName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="ContactTitle" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Fax" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Bool" isPk="False" isAutoInc="False" adoType="-7" sqlType="bit" length="0" isNull="True" />
<index name="City" unique="False" clustered="False">
<column name="City" />
</index>
<index name="CompanyName" unique="False" clustered="False">
<column name="CompanyName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<index name="Region" unique="False" clustered="False">
<column name="Region" />
</index>
<class name="Customer" check="-1" generated="True">
<field name="_customerID" type="1" isPK="True" column="CustomerID" valueType="System.String" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_bool1" type="1" isPK="False" column="Bool" valueType="System.Nullable`1[[System.Boolean, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_contactName" type="1" isPK="False" column="ContactName" valueType="System.String" />
<field name="_contactTitle" type="1" isPK="False" column="ContactTitle" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_fax" type="1" isPK="False" column="Fax" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
</class>
</table>
<table name="'EmployeeTerritories'" type="2" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="TerritoryID" isPk="True" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<constraint name="FK_EmployeeTerritories_Employees" table="'EmployeeTerritories'" dest="'Employees'">
<column name="EmployeeID" />
</constraint>
<constraint name="FK_EmployeeTerritories_Territories" table="'EmployeeTerritories'" dest="'Territories'">
<column name="TerritoryID" />
</constraint>
<field name="_employeeTerritories" type="4" owner="'Employees'" reference="'Territories'">
<mapping field="Employee._employeeID (Owner)" column="EmployeeID" />
<mapping field="Territory._territoryID (Value)" column="TerritoryID" />
</field>
</table>
<table name="'Employees'" type="1" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="LastName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="FirstName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="TitleOfCourtesy" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="25" isNull="True" />
<column name="BirthDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="HireDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="HomePhone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Extension" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="4" isNull="True" />
<column name="Photo" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<column name="Notes" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="ReportsTo" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="PhotoPath" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="255" isNull="True" />
<constraint name="FK_Employees_Employees" table="'Employees'" dest="'Employees'">
<column name="ReportsTo" />
</constraint>
<index name="LastName" unique="False" clustered="False">
<column name="LastName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<class name="Employee" check="-1" generated="True">
<field name="_employeeID" type="1" isPK="True" isAutoInc="True" column="EmployeeID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_birthDate" type="1" isPK="False" column="BirthDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_extension" type="1" isPK="False" column="Extension" valueType="System.String" />
<field name="_firstName" type="1" isPK="False" column="FirstName" valueType="System.String" />
<field name="_hireDate" type="1" isPK="False" column="HireDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_homePhone" type="1" isPK="False" column="HomePhone" valueType="System.String" />
<field name="_lastName" type="1" isPK="False" column="LastName" valueType="System.String" />
<field name="_notes" type="1" isPK="False" column="Notes" valueType="System.String" />
<field name="_photo" type="1" isPK="False" column="Photo" valueType="System.Byte[]" />
<field name="_photoPath" type="1" isPK="False" column="PhotoPath" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
<field name="_reportsTo" type="1" isPK="False" column="ReportsTo" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_titleOfCourtesy" type="1" isPK="False" column="TitleOfCourtesy" valueType="System.String" />
<field name="_employee" type="2" isPK="False" reference="'Employees'">
<mapping field="Employee._employeeID" column="ReportsTo" />
</field>
</class>
</table>
<table name="'LargeEmployees'" type="1" locked="False">
<column name="EmployeeID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="LastName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="FirstName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="TitleOfCourtesy" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="25" isNull="True" />
<column name="BirthDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="HireDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="HomePhone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Extension" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="4" isNull="True" />
<column name="Photo" isPk="False" isAutoInc="False" adoType="-4" sqlType="image" length="2147483647" isNull="True" />
<column name="Notes" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<column name="ReportsTo" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="PhotoPath" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="255" isNull="True" />
<class name="LargeEmployee" check="-1" generated="True">
<field name="_employeeID" type="1" isPK="True" isAutoInc="True" column="EmployeeID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_birthDate" type="1" isPK="False" column="BirthDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_extension" type="1" isPK="False" column="Extension" valueType="System.String" />
<field name="_firstName" type="1" isPK="False" column="FirstName" valueType="System.String" />
<field name="_hireDate" type="1" isPK="False" column="HireDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_homePhone" type="1" isPK="False" column="HomePhone" valueType="System.String" />
<field name="_lastName" type="1" isPK="False" column="LastName" valueType="System.String" />
<field name="_notes" type="1" isPK="False" column="Notes" valueType="System.String" />
<field name="_photo" type="1" isPK="False" column="Photo" valueType="System.Byte[]" />
<field name="_photoPath" type="1" isPK="False" column="PhotoPath" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
<field name="_reportsTo" type="1" isPK="False" column="ReportsTo" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_titleOfCourtesy" type="1" isPK="False" column="TitleOfCourtesy" valueType="System.String" />
</class>
</table>
<table name="'Messages'" type="1" locked="False">
<column name="MessageId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Text" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="False" />
<column name="Date" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="False" />
<column name="Title" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="Sender" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="Receiver" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="True" />
<column name="RadProductId" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="UserId" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_Messages_RadProducts" table="'Messages'" dest="'RadProducts'">
<column name="RadProductId" />
</constraint>
<constraint name="FK_Messages_Users" table="'Messages'" dest="'Users'">
<column name="UserId" />
</constraint>
<class name="Message" check="-1" generated="True">
<field name="_messageId" type="1" isPK="True" isAutoInc="True" column="MessageId" valueType="System.Int32" />
<field name="_date1" type="1" isPK="False" column="Date" valueType="System.DateTime" />
<field name="_radProductId" type="1" isPK="False" column="RadProductId" valueType="System.Int32" />
<field name="_receiver" type="1" isPK="False" column="Receiver" valueType="System.String" />
<field name="_sender" type="1" isPK="False" column="Sender" valueType="System.String" />
<field name="_text" type="1" isPK="False" column="Text" valueType="System.String" />
<field name="_title" type="1" isPK="False" column="Title" valueType="System.String" />
<field name="_userId" type="1" isPK="False" column="UserId" valueType="System.Int32" />
<field name="_radProduct" type="2" isPK="False" reference="'RadProducts'">
<mapping field="RadProduct._radProductId" column="RadProductId" />
</field>
<field name="_user" type="2" isPK="False" reference="'Users'">
<mapping field="User._userId" column="UserId" />
</field>
</class>
</table>
<table name="'Order Details'" type="1" locked="False">
<column name="OrderID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="ProductID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="UnitPrice" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="5" isNull="False" />
<column name="Quantity" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="False" />
<column name="Discount" isPk="False" isAutoInc="False" adoType="7" sqlType="real" length="4" isNull="False" />
<constraint name="FK_Order_Details_Orders" table="'Order Details'" dest="'Orders'">
<column name="OrderID" />
</constraint>
<constraint name="FK_Order_Details_Products" table="'Order Details'" dest="'Products'">
<column name="ProductID" />
</constraint>
<index name="OrderID" unique="False" clustered="False">
<column name="OrderID" />
</index>
<index name="ProductID" unique="False" clustered="False">
<column name="ProductID" />
</index>
<class name="OrderDetail" check="-1" generated="True">
<field name="_orderID" type="1" isPK="True" column="OrderID" valueType="System.Int32" />
<field name="_productID" type="1" isPK="True" column="ProductID" valueType="System.Int32" />
<field name="_discount" type="1" isPK="False" column="Discount" valueType="System.Single" />
<field name="_quantity" type="1" isPK="False" column="Quantity" valueType="System.Int16" />
<field name="_unitPrice" type="1" isPK="False" column="UnitPrice" valueType="System.Decimal" />
<field name="_order" type="2" isPK="False" reference="'Orders'">
<mapping field="Order._orderID" column="OrderID" />
</field>
<field name="_product" type="2" isPK="False" reference="'Products'">
<mapping field="Product._productID" column="ProductID" />
</field>
</class>
</table>
<table name="'Orders'" type="1" locked="False">
<column name="OrderID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CustomerID" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="5" isNull="True" />
<column name="EmployeeID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="OrderDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="RequiredDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="ShippedDate" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<column name="ShipVia" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="Freight" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="6" isNull="True" />
<column name="ShipName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="True" />
<column name="ShipAddress" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="ShipCity" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="ShipRegion" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="ShipPostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="ShipCountry" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<constraint name="FK_Orders_Customers" table="'Orders'" dest="'Customers'">
<column name="CustomerID" />
</constraint>
<constraint name="FK_Orders_Employees" table="'Orders'" dest="'Employees'">
<column name="EmployeeID" />
</constraint>
<constraint name="FK_Orders_Shippers" table="'Orders'" dest="'Shippers'">
<column name="ShipVia" />
</constraint>
<index name="CustomerID" unique="False" clustered="False">
<column name="CustomerID" />
</index>
<index name="EmployeeID" unique="False" clustered="False">
<column name="EmployeeID" />
</index>
<index name="OrderDate" unique="False" clustered="False">
<column name="OrderDate" />
</index>
<index name="ShippedDate" unique="False" clustered="False">
<column name="ShippedDate" />
</index>
<index name="ShippersOrders" unique="False" clustered="False">
<column name="ShipVia" />
</index>
<index name="ShipPostalCode" unique="False" clustered="False">
<column name="ShipPostalCode" />
</index>
<class name="Order" check="-1" generated="True">
<field name="_orderID" type="1" isPK="True" isAutoInc="True" column="OrderID" valueType="System.Int32" />
<field name="_customerID" type="1" isPK="False" column="CustomerID" valueType="System.String" />
<field name="_employeeID" type="1" isPK="False" column="EmployeeID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_freight" type="1" isPK="False" column="Freight" valueType="System.Nullable`1[[System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_orderDate" type="1" isPK="False" column="OrderDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_requiredDate" type="1" isPK="False" column="RequiredDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_shipAddress" type="1" isPK="False" column="ShipAddress" valueType="System.String" />
<field name="_shipCity" type="1" isPK="False" column="ShipCity" valueType="System.String" />
<field name="_shipCountry" type="1" isPK="False" column="ShipCountry" valueType="System.String" />
<field name="_shipName" type="1" isPK="False" column="ShipName" valueType="System.String" />
<field name="_shipPostalCode" type="1" isPK="False" column="ShipPostalCode" valueType="System.String" />
<field name="_shipRegion" type="1" isPK="False" column="ShipRegion" valueType="System.String" />
<field name="_shipVia" type="1" isPK="False" column="ShipVia" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_shippedDate" type="1" isPK="False" column="ShippedDate" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_customer" type="2" isPK="False" reference="'Customers'">
<mapping field="Customer._customerID" column="CustomerID" />
</field>
<field name="_employee" type="2" isPK="False" reference="'Employees'">
<mapping field="Employee._employeeID" column="EmployeeID" />
</field>
<field name="_shipper" type="2" isPK="False" reference="'Shippers'">
<mapping field="Shipper._shipperID" column="ShipVia" />
</field>
</class>
</table>
<table name="'Products'" type="1" locked="False">
<column name="ProductID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="ProductName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="SupplierID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="CategoryID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<column name="QuantityPerUnit" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="True" />
<column name="UnitPrice" isPk="False" isAutoInc="False" adoType="3" sqlType="decimal" length="5" isNull="True" />
<column name="UnitsInStock" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="UnitsOnOrder" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="ReorderLevel" isPk="False" isAutoInc="False" adoType="5" sqlType="smallint" length="0" isNull="True" />
<column name="Discontinued" isPk="False" isAutoInc="False" adoType="-7" sqlType="bit" length="0" isNull="False" />
<column name="voa_class" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="pges" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="True" />
<index name="CategoriesProducts" unique="False" clustered="False">
<column name="CategoryID" />
</index>
<class name="Product" check="-1" generated="True">
<field name="_productID" type="1" isPK="True" isAutoInc="True" column="ProductID" valueType="System.Int32" />
<field name="_categoryID" type="1" isPK="False" column="CategoryID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_classType" type="1" isPK="False" column="voa_class" valueType="System.Int32" />
<field name="_discontinued" type="1" isPK="False" column="Discontinued" valueType="System.Boolean" />
<field name="_pges" type="1" isPK="False" column="pges" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_productName" type="1" isPK="False" column="ProductName" valueType="System.String" />
<field name="_quantityPerUnit" type="1" isPK="False" column="QuantityPerUnit" valueType="System.String" />
<field name="_reorderLevel" type="1" isPK="False" column="ReorderLevel" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_supplierID" type="1" isPK="False" column="SupplierID" valueType="System.Nullable`1[[System.Int32, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitPrice" type="1" isPK="False" column="UnitPrice" valueType="System.Nullable`1[[System.Decimal, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitsInStock" type="1" isPK="False" column="UnitsInStock" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_unitsOnOrder" type="1" isPK="False" column="UnitsOnOrder" valueType="System.Nullable`1[[System.Int16, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
</class>
</table>
<table name="'Prueba'" type="1" locked="False">
<column name="ID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Apellidos" isPk="False" isAutoInc="False" adoType="12" sqlType="varchar" length="30" isNull="True" />
<column name="Nombres" isPk="False" isAutoInc="False" adoType="12" sqlType="varchar" length="30" isNull="True" />
<column name="Fecha" isPk="False" isAutoInc="False" adoType="93" sqlType="datetime" length="0" isNull="True" />
<class name="Prueba" check="-1" generated="True">
<field name="_id" type="1" isPK="True" isAutoInc="True" column="ID" valueType="System.Int32" />
<field name="_apellidos" type="1" isPK="False" column="Apellidos" valueType="System.String" />
<field name="_fecha" type="1" isPK="False" column="Fecha" valueType="System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]" />
<field name="_nombres" type="1" isPK="False" column="Nombres" valueType="System.String" />
</class>
</table>
<table name="'RadProducts'" type="1" locked="False">
<column name="RadProductId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Name" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Description" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="200" isNull="True" />
<class name="RadProduct" check="-1" generated="True">
<field name="_radProductId" type="1" isPK="True" isAutoInc="True" column="RadProductId" valueType="System.Int32" />
<field name="_description" type="1" isPK="False" column="Description" valueType="System.String" />
<field name="_name" type="1" isPK="False" column="Name" valueType="System.String" />
</class>
</table>
<table name="'Region'" type="1" locked="False">
<column name="RegionID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RegionDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<class name="Region" check="-1" generated="True">
<field name="_regionID" type="1" isPK="True" column="RegionID" valueType="System.Int32" />
<field name="_regionDescription" type="1" isPK="False" column="RegionDescription" valueType="System.String" />
</class>
</table>
<table name="'Region_new'" type="1" locked="False">
<column name="RegionID" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RegionDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<class name="RegionNew" check="-1" generated="True">
<field name="_regionID" type="1" isPK="True" column="RegionID" valueType="System.Int32" />
<field name="_regionDescription" type="1" isPK="False" column="RegionDescription" valueType="System.String" />
</class>
</table>
<table name="'Shippers'" type="1" locked="False">
<column name="ShipperID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<class name="Shipper" check="-1" generated="True">
<field name="_shipperID" type="1" isPK="True" isAutoInc="True" column="ShipperID" valueType="System.Int32" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
</class>
</table>
<table name="'Suppliers'" type="1" locked="False">
<column name="SupplierID" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="CompanyName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="40" isNull="False" />
<column name="ContactName" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="ContactTitle" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="30" isNull="True" />
<column name="Address" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="60" isNull="True" />
<column name="City" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Region" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="PostalCode" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<column name="Country" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="15" isNull="True" />
<column name="Phone" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="Fax" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="24" isNull="True" />
<column name="HomePage" isPk="False" isAutoInc="False" adoType="2005" sqlType="ntext" length="0" isNull="True" />
<index name="CompanyName" unique="False" clustered="False">
<column name="CompanyName" />
</index>
<index name="PostalCode" unique="False" clustered="False">
<column name="PostalCode" />
</index>
<class name="Supplier" check="-1" generated="True">
<field name="_supplierID" type="1" isPK="True" isAutoInc="True" column="SupplierID" valueType="System.Int32" />
<field name="_address" type="1" isPK="False" column="Address" valueType="System.String" />
<field name="_city" type="1" isPK="False" column="City" valueType="System.String" />
<field name="_companyName" type="1" isPK="False" column="CompanyName" valueType="System.String" />
<field name="_contactName" type="1" isPK="False" column="ContactName" valueType="System.String" />
<field name="_contactTitle" type="1" isPK="False" column="ContactTitle" valueType="System.String" />
<field name="_country" type="1" isPK="False" column="Country" valueType="System.String" />
<field name="_fax" type="1" isPK="False" column="Fax" valueType="System.String" />
<field name="_homePage" type="1" isPK="False" column="HomePage" valueType="System.String" />
<field name="_phone" type="1" isPK="False" column="Phone" valueType="System.String" />
<field name="_postalCode" type="1" isPK="False" column="PostalCode" valueType="System.String" />
<field name="_region" type="1" isPK="False" column="Region" valueType="System.String" />
</class>
</table>
<table name="'Territories'" type="1" locked="False">
<column name="TerritoryID" isPk="True" isAutoInc="False" adoType="12" sqlType="nvarchar" length="20" isNull="False" />
<column name="TerritoryDescription" isPk="False" isAutoInc="False" adoType="1" sqlType="nchar" length="50" isNull="False" />
<column name="RegionID" isPk="False" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_Territories_Region" table="'Territories'" dest="'Region'">
<column name="RegionID" />
</constraint>
<class name="Territory" check="-1" generated="True">
<field name="_territoryID" type="1" isPK="True" column="TerritoryID" valueType="System.String" />
<field name="_regionID" type="1" isPK="False" column="RegionID" valueType="System.Int32" />
<field name="_territoryDescription" type="1" isPK="False" column="TerritoryDescription" valueType="System.String" />
<field name="_region" type="2" isPK="False" reference="'Region'">
<mapping field="Region._regionID" column="RegionID" />
</field>
</class>
</table>
<table name="'Users'" type="1" locked="False">
<column name="UserId" isPk="True" isAutoInc="True" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="Name" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Email" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="50" isNull="False" />
<column name="Image" isPk="False" isAutoInc="False" adoType="12" sqlType="nvarchar" length="10" isNull="True" />
<class name="User" check="-1" generated="True">
<field name="_userId" type="1" isPK="True" isAutoInc="True" column="UserId" valueType="System.Int32" />
<field name="_email" type="1" isPK="False" column="Email" valueType="System.String" />
<field name="_image" type="1" isPK="False" column="Image" valueType="System.String" />
<field name="_name" type="1" isPK="False" column="Name" valueType="System.String" />
</class>
</table>
<table name="'UsersRadProducts'" type="2" locked="False">
<column name="UserId" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<column name="RadProductId" isPk="True" isAutoInc="False" adoType="4" sqlType="int" length="0" isNull="False" />
<constraint name="FK_UsersRadProducts_RadProducts" table="'UsersRadProducts'" dest="'RadProducts'">
<column name="RadProductId" />
</constraint>
<constraint name="FK_UsersRadProducts_Users" table="'UsersRadProducts'" dest="'Users'">
<column name="UserId" />
</constraint>
<field name="_usersRadProducts" type="4" owner="'RadProducts'" reference="'Users'">
<mapping field="RadProduct._radProductId (Owner)" column="RadProductId" />
<mapping field="User._userId (Value)" column="UserId" />
</field>
</table>
</classGenerator>
<options>
<sourcegeneration partial="True" />
<allSchemata>
<schemata name="(default)" />
</allSchemata>
<usedSchemata>
<schemata name="(default)" />
</usedSchemata>
<mapping>
<identity explicitIDClass="False" />
</mapping>
</options>
</openaccess>
0
juance
Top achievements
Rank 1
answered on 08 Apr 2009, 11:05 AM
The error ocurs too whe copy a table, I see the definition in the reverse mapping file but the class is not generated
Example
In the reverse mapping you sendit existe the table region_new but the region_new.vb no is generated
Thanks in advance andperdon for my bad english
My best regards
Example
In the reverse mapping you sendit existe the table region_new but the region_new.vb no is generated
Thanks in advance andperdon for my bad english
My best regards
0
Hello juance,
Thank you for the config file. There was a bug in the merge functionality while handling class namespaces in VB. This has been fixed.
You should be able to generate the classes if you use the Reverse Mapping wizard again with the reversemapping.config file that you sent me.
Your Telerik points have been updated.
Regards,
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
Thank you for the config file. There was a bug in the merge functionality while handling class namespaces in VB. This has been fixed.
You should be able to generate the classes if you use the Reverse Mapping wizard again with the reversemapping.config file that you sent me.
Your Telerik points have been updated.
Regards,
Ady
the Telerik team
Check out Telerik Trainer , the state of the art learning tool for Telerik products.
0
juance
Top achievements
Rank 1
answered on 08 Apr 2009, 07:25 PM
Ok. thank you
My best regards
My best regards
0
Richard
Top achievements
Rank 1
answered on 14 Apr 2009, 02:25 PM
I encountered exactly the same error.
But I can't find any solution in your posting nor a hotfix in your download area.
What should I have to do?
Greetings
Richard
But I can't find any solution in your posting nor a hotfix in your download area.
What should I have to do?
Greetings
Richard
0
Hello Richard,
Here is what you can do -
Do let me know if this solves your problem.
Regards,
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
Here is what you can do -
1. After a merge, save the settings and close the wizard
2. Open the reversemapping.config file in Visual Studio
3. For each newly added table, go to the <class> node under the <table> node and remove the 'namespace' attribute and value,if present.
4. Execute the wizard again and everything should work as expected.
Do let me know if this solves your problem.
Regards,
Ady
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
0
juance
Top achievements
Rank 1
answered on 15 Apr 2009, 12:59 AM
Yes thank you
I can fix this by giving a different default namespace too
My best regards
I can fix this by giving a different default namespace too
My best regards
0
Tony
Top achievements
Rank 1
answered on 26 Jun 2009, 10:54 PM
I experienced this bug too. the steps helped.