LinQ 2 mySQL Build Problem

LinQ 2 mySQL Build Problem

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby AndreyR » Fri 16 Jan 2009 12:08

Could you please send me (andreyr * devart * com) both DBML model and DataContext class?
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby Zero-G. » Fri 16 Jan 2009 18:15

Hey

Any news?
I have mailed you the sample dbml.

THx
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to LinqConnect (LINQ to SQL support)