Linq Beta and AutoIncrement fields

Linq Beta and AutoIncrement fields

Postby 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.


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

//client has an auto increment field called client_id


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?

Posts: 9
Joined: Thu 28 Aug 2008 20:24

Postby Shalex » Fri 29 Aug 2008 16:57

We have fixed this problem for you.
Look forward to the next build.
Devart Team
Posts: 7893
Joined: Thu 14 Aug 2008 12:44

Postby » 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"?

When is this next build going to be released?
Last edited by on Thu 17 Feb 2011 05:19, edited 1 time in total.
Posts: 43
Joined: Wed 17 Sep 2008 11:31

Postby 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
Devart Team
Posts: 7893
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Wed 08 Oct 2008 09:45

LINQ to MySQL Support version 1.00.2 Beta is available!
Please refer to
Devart Team
Posts: 7893
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for MySQL