Problem with merge

10 posts, 0 answers
  1. juance
    juance avatar
    16 posts
    Member since:
    Jul 2006

    Posted 07 Apr 2009 Link to this post

    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.
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 08 Apr 2009 Link to this post

    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,
    Ady
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  3. DevCraft banner
  4. juance
    juance avatar
    16 posts
    Member since:
    Jul 2006

    Posted 08 Apr 2009 Link to this post

    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>


  5. juance
    juance avatar
    16 posts
    Member since:
    Jul 2006

    Posted 08 Apr 2009 Link to this post

    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

  6. Ady
    Admin
    Ady avatar
    589 posts

    Posted 08 Apr 2009 Link to this post

    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,
    Ady
    the Telerik team

    Check out Telerik Trainer , the state of the art learning tool for Telerik products.
  7. juance
    juance avatar
    16 posts
    Member since:
    Jul 2006

    Posted 08 Apr 2009 Link to this post

    Ok. thank you

    My best regards
  8. Richard
    Richard avatar
    8 posts
    Member since:
    Sep 2008

    Posted 14 Apr 2009 Link to this post

    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
  9. Ady
    Admin
    Ady avatar
    589 posts

    Posted 14 Apr 2009 Link to this post

    Hello Richard,

     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.
  10. juance
    juance avatar
    16 posts
    Member since:
    Jul 2006

    Posted 14 Apr 2009 Link to this post

    Yes thank you
    I can fix this by giving a different default namespace too

    My best regards
  11. Tony
    Tony avatar
    2 posts
    Member since:
    Mar 2009

    Posted 26 Jun 2009 Link to this post

    I experienced this bug too.  the steps helped.
Back to Top
DevCraft banner