you'd have to set the IDENTITY field in the DB yourself.
On Thu, Feb 12, 2009 at 9:00 AM, Martin Nilsson <[email protected]> wrote:
> Number 1, is that possible with AR? I can't have it as a primary key but as
> a normal property. Tried a little bit with the Formula parameter for
> PropertyAttribute but didn't had any progress there either.
>
> [ActiveRecord]
> public class Order
> {
> [PrimaryKey(PrimaryKeyType.GuidComb)]
> public Guid Id {get; set;}
>
> [Property(??)]
> public int OrderNumber {get; set;}
> }
>
> On Wed, Feb 11, 2009 at 3:29 PM, Ken Egozi <[email protected]> wrote:
>
>> off the top of my head:
>> 1. you can set it as a readonly property, and have the DB initiate the
>> value (in SQL server use IDENTITY(1000, 1) ). I think you'd need to set the
>> field as int? so it won't try to save 0 to the DB
>> 2. call the DB when inserting to get the highest OrderNumber and plus 1 it
>> 3. If you know for sure that only the application can access the DB, you
>> might consider setting a variable with the last OrderNumber, increasing it
>> when needed with an appropriate logging mechanism.
>>
>>
>> On Wed, Feb 11, 2009 at 4:15 PM, Martin Nilsson <[email protected]>wrote:
>>
>>> How do I best setup my active record class to have a natural key. Instead
>>> of guid as order number I want a sequence that starts with 10000 for
>>> example.
>>>
>>> [ActiveRecord]
>>> public class Order
>>> {
>>> [PrimaryKey(PrimaryKeyType.GuidComb)]
>>> public Guid Id {get; set;}
>>>
>>> [??]
>>> public int OrderNumber {get; set;}
>>> }
>>>
>>> Note that I will still have guid as id to keep track of if it is saved or
>>> not but I want to show the customer a more friendly order number.
>>>
>>>
>>>
>>
>>
>> --
>> Ken Egozi.
>> http://www.kenegozi.com/blog
>> http://www.delver.com
>> http://www.musicglue.com
>> http://www.castleproject.org
>> http://www.gotfriends.co.il
>>
>>
>>
>
> >
>
--
Ken Egozi.
http://www.kenegozi.com/blog
http://www.delver.com
http://www.musicglue.com
http://www.castleproject.org
http://www.gotfriends.co.il
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Castle Project Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/castle-project-users?hl=en
-~----------~----~----~----~------~----~------~--~---
