[Table("Membership")]
public class Membership
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int id { get; set; }
[Key]
public string MembershipID { get; set; }
public string MembershipType { get; set; }
}
using this model, How can I generate in my MembershipID a IDENTITY sequence and a padding.
ex.
M00005 - where 5 is the value of my id. I use a trigger before but its generate a lots of error. That why I delete my trigger.
Please assist me on this. Thanks.
or
How Can I do this ----
Id MembershipId
1 M00001
2 M00002
3 M00003
4 M00004
without using an SQL function, coz if I use sql function I can't make the MembershipID as my primarey key. sql function takes a null value.
emeraldjunn2...
0 Points
10 Posts
Field Identity and Key Sequence
Nov 18, 2012 09:58 AM|LINK
I have Membership Class in my model
[Table("Membership")]
public class Membership
{
[DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int id { get; set; }
[Key]
public string MembershipID { get; set; }
public string MembershipType { get; set; }
}
using this model, How can I generate in my MembershipID a IDENTITY sequence and a padding.
ex.
M00005 - where 5 is the value of my id. I use a trigger before but its generate a lots of error. That why I delete my trigger.
Please assist me on this. Thanks.
or
How Can I do this ----
Id MembershipId
1 M00001
2 M00002
3 M00003
4 M00004
without using an SQL function, coz if I use sql function I can't make the MembershipID as my primarey key. sql function takes a null value.
Thanks in advance.
RameshRajend...
Star
7983 Points
2099 Posts
Re: Field Identity and Key Sequence
Nov 18, 2012 12:38 PM|LINK
Hai
Please ref this
http://stackoverflow.com/questions/10062328/sequence-vs-identity