Linq Beta and AutoIncrement fields

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Andrew
Posts: 9
Joined: Thu 28 Aug 2008 20:24

Linq Beta and AutoIncrement fields

Post by Andrew » Thu 28 Aug 2008 20:32

Hi all

I am experimenting with Linq and the Schema Modeller. I have a database id field that is an AutoIncrement field.

I can successfully insert a new row with linq, but the object is not updated with the id.

Example:

Code: Select all

client c = new client { client_name = clRow["name"].ToString() };

//client has an auto increment field called client_id

db.clients.InsertOnSubmit(c);
db.SubmitChanges();

Console.Write("client_id = " + c.client_id); //client_id is 0


In the Schema Modeller these attributes are set:

Access: Public
Delay Loaded: False
Inheritance Modifier: None
Name: client_id
Type: System.Int64

Auto Generated Value: True
Auto-Sync: OnInsert
Is Version: False
Nullable: False
Primary Key: True
Read Only: False
Server Data Type: int(10) Not Null Auto_increment
Source: client_id
Update Check: Always

Any ideas on why the id field is not synced on my object after the submit?
Thanks!
Andrew

[/code]

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 29 Aug 2008 16:57

We have fixed this problem for you.
Look forward to the next build.

[email protected]
Posts: 43
Joined: Wed 17 Sep 2008 11:31

Post by [email protected] » Wed 17 Sep 2008 11:36

Do we have to look forward to the next build of "LINQ Support" or "MyDirect .NET"?

Is there also a history for "LINQ Support" like for "MyDirect .NET"?
(http://www.devart.com/mysqlnet/History.html)

When is this next build going to be released?
________
POT NEWS
Last edited by [email protected] on Thu 17 Feb 2011 05:19, edited 1 time in total.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 18 Sep 2008 11:06

It was a LINQ Support problem. The next build of LINQ Support will be available in 1 month. Now the LINQ Support history contains only one record:
1.00.1 Beta 04-Aug-08
  • First release of LINQ Support

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 08 Oct 2008 09:45

LINQ to MySQL Support version 1.00.2 Beta is available!
Please refer to http://www.devart.com/forums/viewtopic.php?t=13062

Post Reply