Version 3.0.5 BUG!!!

Version 3.0.5 BUG!!!

Postby Zero-G. » Thu 13 Oct 2011 15:52

Hey
I have just upraded to the new version

In a normal SubmitChanges, which has worked till yet, I get an error when I try to insert a new row.
The generated code looks like this:

Code: Select all
SELECT t1.ID, t1.firmenname, t1.strasse, t1.plz, t1.ort, t1.telefon, t1.fax, t1.handy, t1.email, t1.homepage, t1.geschaeftstyp, t1.farbe, t1.Zeitstempel
FROM firmendaten t1
WHERE :np0 = t1.ID
-- np0: Input BigInt (Size = 0; DbType = Int64) [1]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

SELECT t1.ID, t1.firmenname, t1.strasse, t1.plz, t1.ort, t1.telefon, t1.fax, t1.handy, t1.email, t1.homepage, t1.geschaeftstyp, t1.farbe, t1.Zeitstempel
FROM firmendaten t1
WHERE :np0 = t1.ID
-- np0: Input BigInt (Size = 0; DbType = Int64) [2]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

UPDATE artikelstammdetails SET lagermenge = :p1, datlzug = :p2 WHERE id = :key1 AND Zeitstempel = :chk1
-- p1: Input Int (Size = 0; DbType = Int32) [0]
-- p2: Input Date (Size = 0; DbType = Date) [13.10.2011 17:50:40]
-- key1: Input BigInt (Size = 0; DbType = Int64) [32084]
-- chk1: Input TimeStamp (Size = 0; DbType = DateTime) [16.08.2011 13:38:57]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

SELECT Zeitstempel FROM artikelstammdetails WHERE id = :key1
-- key1: Input BigInt (Size = 0; DbType = Int64) [32084]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

UPDATE artikelstammdetails SET lagermenge = :p1, datlzug = :p2 WHERE id = :key1 AND Zeitstempel = :chk1
-- p1: Input Int (Size = 0; DbType = Int32) [1]
-- p2: Input Date (Size = 0; DbType = Date) [13.10.2011 17:50:40]
-- key1: Input BigInt (Size = 0; DbType = Int64) [66490]
-- chk1: Input TimeStamp (Size = 0; DbType = DateTime) [23.12.2010 15:29:02]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

SELECT Zeitstempel FROM artikelstammdetails WHERE id = :key1
-- key1: Input BigInt (Size = 0; DbType = Int64) [66490]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

INSERT INTO lagerzugang (von, nach, Zugang, Datum_Eingabe, Datum_Uebertragung, Erledigt) VALUES (:p1, :p2, :p3, :p4, :p5, :p6)
-- p1: Input BigInt (Size = 0; DbType = Int64) [1]
-- p2: Input BigInt (Size = 0; DbType = Int64) [2]
-- p3: Input Blob (Size = 319; DbType = Binary) [System.Byte[]]
-- p4: Input DateTime (Size = 0; DbType = DateTime) [13.10.2011 17:50:40]
-- p5: Input DateTime (Size = 0; DbType = DateTime) []
-- p6: Input Int (Size = 0; DbType = Int32) [0]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0

SELECT Zeitstempel FROM lagerzugang WHERE ID = ::ask
-- ask: Input BigInt (Size = 0; DbType = Int64) [7852]
-- Context: Devart.Data.MySql.Linq.Provider.MySqlDataProvider Model: an Build: 3.0.5.0


As you can see in the last Select Statement, there are two
:


Please help - THX
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby StanislavK » Fri 14 Oct 2011 12:41

Thank you for the report, we have reproduced and fixed this problem. The fix will be available in the nearest build.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to LinqConnect (LINQ to SQL support)