LinQ 2 mySQL Build Problem

Zero-G. · Post by **Zero-G.** » Thu 15 Jan 2009 22:18

Hey
I use your tools: 5.0.16 (mySQL)

I have a field definied in my DataBase called "Zeitstempel" it is a timestamp field with Default Value = Current_Time_Stamp, AllowDBNull = False, so in the O/R Designer the field has the following server Data Type: timestamp NOT NULL
Creating the dbml file is working fine.
After inserting all created files into a new VB.NET project & try to build I get the following error: Fehler 1 DBML1005: Die Zuordnung zwischen DbType "timestamp NOT NULL" und Type "System.DateTime" in Column "`Zeitstempel`" von Type "aerzte" wird nicht unterstützt. 0 0

Translated: The mapping between DbType "timestamp NOT NULL" and type "System.DateTim" in Column "Zeitstempel" from type "aerzte" is not supported.

THX

AndreyR · Post by **AndreyR** » Fri 16 Jan 2009 12:08

Could you please send me (andreyr * devart * com) both DBML model and DataContext class?

Zero-G. · Post by **Zero-G.** » Fri 16 Jan 2009 18:15

Hey

Any news?
I have mailed you the sample dbml.

THx

Zero-G. · Post by **Zero-G.** » Sun 18 Jan 2009 17:13

In the schema I have send you, I found one more problem.

Please take a look on the table "firmendaten" - There is a fiel called "farbe" - This has a RGB Color in it. - In my case: -6697729
By Filling the data. - This has the Value: NOTHING

Please take a look too!

THX

AndreyR · Post by **AndreyR** » Mon 19 Jan 2009 11:47

Change the Custom Tool property of the model from MSLinqToSQLGenerator to DevartLinqToSQLGenerator
and try to rebuild the project. Let me know if the problem persists.