Wouldn't it be possible to have a
[Field("some_auto_incrementing_field_in_db", Update = false)]
public int OrderNumber;
perhaps? I'm trying the Update = false thing right now myself, I'll let
you know if I'm successful :)
Martin Nilsson 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]
> <mailto:[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] <mailto:[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
>
>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
