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.

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]
Andrew
 
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.
Shalex
Devart Team
 
Posts: 7527
Joined: Thu 14 Aug 2008 12:44

Postby itcore@vit.ch » 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 itcore@vit.ch on Thu 17 Feb 2011 05:19, edited 1 time in total.
itcore@vit.ch
 
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
Shalex
Devart Team
 
Posts: 7527
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 http://www.devart.com/forums/viewtopic.php?t=13062
Shalex
Devart Team
 
Posts: 7527
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL