Issue 334 in dblinq2007: "The given key was not present in the dictionary"

4 views
Skip to first unread message

dblin...@googlecode.com

unread,
Nov 8, 2012, 1:34:53 AM11/8/12
to dblin...@googlegroups.com
Status: New
Owner: ----

New issue 334 by hardi...@gmail.com: "The given key was not present in the
dictionary"
http://code.google.com/p/dblinq2007/issues/detail?id=334

What steps will reproduce the problem?
1. Add a Foreign Key to a SQLite database
2. DbMetal /provider:Sqlite /conn "Data Source=bms4.db3" /dbml:Model.dbml

I am getting this error:
>>> Reading schema from SQLite database
DbMetal: The given key was not present in the dictionary.

What version of the product are you using? 0.20.1
On what operating system? Windows XP

This is my SQLite database

CREATE TABLE [Categories] (
[ParentId] INT,
[Name] VARCHAR(100));


CREATE TABLE [Fees] (
[CategoryId] INT,
[Name] VARCHAR(100),
[Value] VARCHAR(50),
[Info] VARCHAR(200));


CREATE TABLE [Markups] (
[CategoryId] INT,
[UpTo] MONEY,
[Value] VARCHAR(50),
[Info] VARCHAR(200));

That will create the .dbml file successfully.
But once you add a Foreign Key to [Fees], DBLinq will fail
(I have made the FK name lowercase as suggested by others)

CREATE TABLE [Fees] (
[CategoryId] INT CONSTRAINT [fk_fees_categories] REFERENCES
[Categories]([rowid]),
[Name] VARCHAR(100),
[Value] VARCHAR(50),
[Info] VARCHAR(200));

Could someone help me please?

Reply all
Reply to author
Forward
0 new messages