Hello, I have a MySQL database with a few tables which have indexes and identifying as well as non-identifying relationships established (i.e. primary and foreign keys, constraints). I also have about 20 tables in this database.
I am trying to create the objects using sqlmetal on Ubuntu Linux. The command I use is as follows: sqlmetal /provider:MySQL /server:localhost /database:mydbname / user:myuser /passwo rd:mypassword /pluralize /debug /namespace=tpems.Model / code=TpemsDbModel.cs I get an number of errors when I run the command (see below for the debug output). I am able to generate using very simple (1 or 2 tables). What am I doing wrong? Anyone please help! Thank you. 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 sqlmetal: System.InvalidOperationException: Operation is not valid due to the current state of the object at System.Linq.Enumerable.Single[Column] (IEnumerable`1 source, System.Func`2 predicate, Fallback fallback) [0x00000] in <filename unknown>:0 at System.Linq.Enumerable.Single[Column] (IEnumerable`1 source, System.Func`2 predicate) [0x00000] in <filename unknown>:0 at DbMetal.Generator.Implementation.Processor.ValidateAssociations (DbLinq.Schema.Dbml.Database database, DbLinq.Schema.Dbml.Table table) [0x00000] in <filename unknown>:0 at DbMetal.Generator.Implementation.Processor.SchemaIsValid (DbLinq.Schema.Dbml.Database database) [0x00000] in <filename unknown>: 0 at DbMetal.Generator.Implementation.Processor.ProcessSchema (DbMetal.Parameters parameters) [0x00000] in <filename unknown>:0 -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
