I am evaluating dotConnect for SQLite (with VS2010/.NET 4.0) and generating a LINQ2SQL DataContext from a small existing database (DB first model). One of the tables models a tree structure, with a parent "foreign" key to the same table. The entity name is Portfolio and the "foreign" key is ParentId, annotated as FK_Parent in the existing database. The generated lqml creates a generically named association for this as "Portfolio_Portfolio" with members with similarly generic names ("Portfolios", "Portfolio1").
I can edit the association in the design view, but the Designer.cs file is never updated, nor is the lqml file.
"Run custom tool" in the context menu, as I discovered, runs the Entity Framework tool and totally destroys the lqml file.
Other than manually editing the Designer.cs file, I can see no way to update the association names from the generated names.
Am I correct in assuming that a manual edit is the only option for this?
Thanks.