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
Please help - THX: