How to use string property as ID

[Paresh]

Hi,

I want to define one of the string property in my class as ID (application generated).
I tried following 
configuration.HasProperty(x => x.Name).IsIdentity(KeyGenerator.Default).ToColumn("astCode").HasColumnType("nvarchar");

But it generates following error

The type 'Telerik.OpenAccess.Metadata.Fluent.StringPropertyConfiguration' cannot be used as type parameter 'TConfiguration' in the generic type or method 'Telerik.OpenAccess.Metadata.Fluent.FluentIdentityConfigurationExtensions.IsIdentity<TConfiguration>(TConfiguration, Telerik.OpenAccess.Metadata.KeyGenerator)'. There is no implicit reference conversion from 'Telerik.OpenAccess.Metadata.Fluent.StringPropertyConfiguration' to 'Telerik.OpenAccess.Metadata.Fluent.IIdentityKeyGenConfiguration'

Thanks,
Paresh

[Boris Georgiev]

Hello Paresh,

If you want to have string property(varchar column) as a Primary Key, you should not pass KeyGenerator parameter in the IsIdentity() method. The KeyGenerator enum should be used, if you have GUID or int column and you want to have KeyGenerator - Autoinc, IncrementalGuil and to not specify manually the key. But for varchar columns there isn't any KeyGenerator, so you should manually set the PrimaryKey value. In conclusion in your case the fluent definition for the property should look like:

configuration.HasProperty(x => x.Name).IsIdentity().ToColumn("astCode").HasColumnType("nvarchar");

I hope that helps.

Regards,
Boris Georgiev
Telerik