This question is locked. New answers and comments are not allowed.
I'm new to the OpenAccess ORM, and was looking through some of the documentation to get my bearings. I attempted the "Getting Started with Model First Scenario" from this page: http://www.telerik.com/help/openaccess-orm/getting-started-root-getting-started-with-update-schema-tools.html
I followed the steps on that page exactly as directed, but the generated script does not include the join table for the many-to-many relationship between Product and Order. I might be missing something really simple, but I'm sure I followed the tutorial correctly. Any ideas what I've done wrong?
For reference, here is the script that OpenAccess generated:
I followed the steps on that page exactly as directed, but the generated script does not include the join table for the many-to-many relationship between Product and Order. I might be missing something really simple, but I'm sure I followed the tutorial correctly. Any ideas what I've done wrong?
For reference, here is the script that OpenAccess generated:
-- Category
CREATE
TABLE
[category] (
[description]
varchar
(255)
NULL
,
-- _description
[cetegory_id]
int
NOT
NULL
,
-- _cetegoryId
[category_name]
varchar
(255)
NULL
,
-- _categoryName
CONSTRAINT
[pk_category]
PRIMARY
KEY
([cetegory_id])
)
go
-- Ordr
CREATE
TABLE
[ordr] (
[ship_address]
varchar
(255)
NULL
,
-- _shipAddress
[order_id]
int
NOT
NULL
,
-- _orderId
[order_date] datetime
NOT
NULL
,
-- _orderDate
CONSTRAINT
[pk_ordr]
PRIMARY
KEY
([order_id])
)
go
-- Product
CREATE
TABLE
[product] (
[unit_price]
NUMERIC
(20,10)
NOT
NULL
,
-- _unitPrice
[product_name]
varchar
(255)
NULL
,
-- _productName
[product_id]
int
NOT
NULL
,
-- _productId
[discontinued] tinyint
NOT
NULL
,
-- _discontinued
[cetegory_id]
int
NULL
,
-- _cetegoryId
CONSTRAINT
[pk_product]
PRIMARY
KEY
([product_id])
)
go