Problem running DBLinq

[Sid Price]

I am trying to build an application for accessing a MySQL database. When I
run DBMetal I get the following error:

dbmetal.exe --provider=MySQL --server=xx.xx.xx.xx --database=myDb --user=me
--password="goeshere" --dbml =output.dbml

DbLinq Database mapping generator 2008 version 0.20

for Microsoft (R) .NET Framework version 3.5

Distributed under the MIT licence (http://linq.to/db/license)

>>> Reading schema from MySQL database

DbMetal: Sequence contains more than one matching element

Please help me understand the problem and correct it.

Thanks,

Sid.

Avian Ambassadors - Flights of Education

www.AvianAmbassadors.com

The Bird Training Blog <http://avianambassadors.com/BirdTraining/>

Behavior and Training Seminars <http://www.behaviorandtraining.com/>

[Jonathan Pryor]

On Mar 12, 2011, at 6:14 PM, Sid Price wrote:
> I am trying to build an application for accessing a MySQL database. When I
> run DBMetal I get the following error:

...

> DbMetal: Sequence contains more than one matching element

If you use the --debug option, you'll get a full stack trace...which is only helpful if you have source, but is still helpful.

I'm going to guess that the problem is similar to:

http://groups.google.com/group/dblinq/browse_thread/thread/bdce6b4c801c4ba7/5476d33655962045?lnk=gst&q=sqlmetal+produces+error+with+mysql+database#5476d33655962045

Rephrased, I suspect that DbMetal doesn't like your table relationships. You'll need to do some investigation for why DbMetal doesn't like it, and what you can do to work around the problem.

- Jon

[Sid Price]

Thank you for the response. Here is the run with --debug:

C:\DATA_R~1\Temp\DBLINQ~1.1>iaate_code

C:\DATA_R~1\Temp\DBLINQ~1.1>dbmetal.exe --provider=MySQL --server=xxx
--database=xxxx --user=iaateor --password="xxxx" --code=files\iaate_db.vb
--debug --language=VB

DbLinq Database mapping generator 2008 version 0.20
for Microsoft (R) .NET Framework version 3.5
Distributed under the MIT licence (http://linq.to/db/license)

>>> Reading schema from MySQL database

DbMetal: System.InvalidOperationException: Sequence contains more than one
matching element
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2
predicate)
at
DbMetal.Generator.Implementation.Processor.ValidateAssociations(Database
database, Table table) in z:\Development\DbLinq-0.20.
1\src\DbMetal\Generator\Implementation\Processor.cs:line 141
at DbMetal.Generator.Implementation.Processor.SchemaIsValid(Database
database) in z:\Development\DbLinq-0.20.1\src\DbMetal\Genera
tor\Implementation\Processor.cs:line 130
at DbMetal.Generator.Implementation.Processor.ProcessSchema(Parameters
parameters) in z:\Development\DbLinq-0.20.1\src\DbMetal\Ge
nerator\Implementation\Processor.cs:line 112

C:\DATA_R~1\Temp\DBLINQ~1.1>

The database is a live database for a web site so I have no control how the
tabes are built or relationships established, I hope that is not the issue.

Sid.

Avian Ambassadors - Flights of Education
www.AvianAmbassadors.com
The Bird Training Blog

Behavior and Training Seminars

http://groups.google.com/group/dblinq/browse_thread/thread/bdce6b4c801c4ba7/
5476d33655962045?lnk=gst&q=sqlmetal+produces+error+with+mysql+database#5476d
33655962045

- Jon

--
You received this message because you are subscribed to the Google Groups
"DbLinq" group.
To post to this group, send email to dbl...@googlegroups.com.
To unsubscribe from this group, send email to
dblinq+un...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/dblinq?hl=en.