you provided the name of other column - I think that's sufficient.
what results do you get when you read records using NHibernate?
2016-06-08 16:12 GMT+03:00 Fran Knebels <fkneb...@gmail.com>:
> I thought formula was to run arbitrary SQL. From the mapping provided I
> don't see any SQL statement.
> On Jun 8, 2016 1:48 AM, <zhongp...@gmail.com> wrote:
>
>> Forget the environment:
>> NHibernate Version: 4.0.4.4000
>> Fluent NHibernate Version : 2.0.3.0
>> Sql Server 2014
>>
>>
>>
>>
>> On Wednesday, June 8, 2016 at 12:53:56 AM UTC+8, zhon...@gmail.com wrote:
>>>
>>>
>>>
>>>
>>> Class definition:
>>>
>>> public class worker
>>> {
>>> public virtual float Balance { get; set; }
>>> public virtual int? Age { get; set; }
>>> public virtual string Name { get; set; }
>>> public virtual Sex Sex { get; set; }
>>> public virtual string HomeAddress { get; set; }
>>> public virtual DateTime Birthday { get; set; }
>>> public virtual int Id { get;}
>>> public virtual byte[] Image { get; set; }
>>> public virtual string Region { get; set; }
>>> public virtual string City { get; set; }
>>> }
>>>
>>>
>>>
>>>
>>>
>>>
>>> Mapping:
>>>
>>> Map(w => w.Region)
>>> .Column("WorkerRegion")
>>> .CustomSqlType("char(6)")
>>> .Not.Nullable().Index("WorkerRegion_Index");
>>>
>>>
>>> Map(w => w.City,"WorkerCity")
>>> .CustomSqlType("nvarchar(26)")
>>> .Formula("WorkerRegion");
>>>
>>>
>>> Configuration:
>>>
>>> internal static class NhibernateHelper
>>> {
>>> private static readonly Lazy<ISessionFactory> SessionFactory=new
>>> Lazy<ISessionFactory>(GetSessionFactory,LazyThreadSafetyMode.ExecutionAndPublication);
>>> private const string ConnectionStringKey = "FNHDemo";
>>>
>>> private static ISessionFactory GetSessionFactory()
>>> {
>>> var sessionFactory = Fluently.Configure()
>>> .Database(MsSqlConfiguration.MsSql2012.ConnectionString(c
>>> => c.FromConnectionStringWithKey(ConnectionStringKey)))
>>> .Mappings(m =>
>>> m.FluentMappings.AddFromAssembly(typeof(NhibernateHelper).Assembly))
>>> .ExposeConfiguration(BuildSchema)
>>> .BuildSessionFactory();
>>> return sessionFactory;
>>> }
>>> public static ISession GetSession()
>>> {
>>> return SessionFactory.Value.OpenSession();
>>> }
>>>
>>> public static void BuildSchema(Configuration cfg)
>>> {
>>> new SchemaExport(cfg).Create(true, true);
>>> }
>>> }
>>>
>>>
>>>
>>> Generated Schema Script:
>>>
>>> create table Worker (
>>> WorkerId int IDENTITY NOT NULL,
>>> WorkerBalance decimal(9,4) not null,
>>> WorkerAge tinyint default Month(GetDate()) null,
>>> WorkerBirthday date not null,
>>> WorkerRegion char(6) not null,
>>> WorkerCity nvarchar(26) null,
>>> WorkerSex nvarchar(10) default 'Male' null,
>>> WorkerName nvarchar(4) not null,
>>> WorkerImage binary(2000) null,
>>> primary key (WorkerId)
>>> )
>>>
>>> create index WorkerRegion_Index on Worker (WorkerRegion)
>>>
>>> create index WorkerName_Index on Worker (WorkerName)
>>>
>>>
>>>
>>> Everything seems fine except the WorkerCity Column, never become a
>>> computed column, frustrating, any help will be appreciated.
>>>
>>>
>>> --
>> You received this message because you are subscribed to the Google Groups
>> "Fluent NHibernate" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to fluent-nhibernate+unsubscr...@googlegroups.com.
>> To post to this group, send email to fluent-nhibernate@googlegroups.com.
>> Visit this group at https://groups.google.com/group/fluent-nhibernate.
>> For more options, visit https://groups.google.com/d/optout.
>>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Fluent NHibernate" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/fluent-nhibernate/f-TwS310h5k/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to
> fluent-nhibernate+unsubscr...@googlegroups.com.
> To post to this group, send email to fluent-nhibernate@googlegroups.com.
> Visit this group at https://groups.google.com/group/fluent-nhibernate.
> For more options, visit https://groups.google.com/d/optout.
>
--
Yours faithfully,
Gleb
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to fluent-nhibernate+unsubscr...@googlegroups.com.
To post to this group, send email to fluent-nhibernate@googlegroups.com.
Visit this group at https://groups.google.com/group/fluent-nhibernate.
For more options, visit https://groups.google.com/d/optout.
