Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Answer to the above question:</p> <pre><code>using System; using System.Linq; using System.Reflection; using FluentNHibernate.Cfg; using FluentNHibernate.Cfg.Db; using FluentNHibernate.Mapping; using NHibernate; using NHibernate.Cfg; using NHibernate.Dialect; using NHibernate.Dialect.Function; using NHibernate.Hql.Ast; using NHibernate.Linq.Functions; using NHibernate.Tool.hbm2ddl; using NHibernate.Linq; using System.Collections.ObjectModel; using System.Linq.Expressions; using NHibernate.Linq.Visitors; using NHibernate.Cfg.Loquacious; namespace ConsoleApplication1 { class Program { private static Configuration _config; static void Main(string[] args) {App_Start.NHibernateProfilerBootstrapper.PreStart(); var sessionFactory = CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { BuildSchema(session); using(var transaction = session.BeginTransaction()) { var foo = new Patient { Name = "Foo", Sex = Gender.Male, DateAdded = new DateTime(2009, 1, 4), AdmitDate = new DateTime(2009, 1, 6) }; var bar = new Patient { Name = "Bar", Sex = Gender.Female, DateAdded = new DateTime(2009, 1, 1), AdmitDate = new DateTime(2009, 1, 2) }; session.SaveOrUpdate(foo); session.SaveOrUpdate(bar); transaction.Commit(); } session.Flush(); using (session.BeginTransaction()) { //x.PatientVisit.AdmitDate.Value.Date == x.DateAdded.Date var patients = from c in session.Query&lt;Patient&gt;() where c.DateAdded.AddDays(1) &lt; c.AdmitDate.Value select c; foreach (var cat in patients) { Console.WriteLine("patient name {0}, sex {1}", cat.Name, cat.Sex); } } } Console.ReadKey(); } private static ISessionFactory CreateSessionFactory() { return Fluently.Configure() .Database( MsSqlConfiguration.MsSql2008.Dialect&lt;CustomDialect&gt;() .ConnectionString("Data Source=.;Initial Catalog=testdb;Integrated Security=True;Connection Reset=false") ) .Mappings(m =&gt; m.FluentMappings.AddFromAssemblyOf&lt;Program&gt;()) .ExposeConfiguration(c =&gt; { c.LinqToHqlGeneratorsRegistry&lt;ExtendedLinqtoHqlGeneratorsRegistry&gt;(); _config = c; }) .BuildSessionFactory(); } private static void BuildSchema(ISession session) { new SchemaExport(_config) .Execute(true, true, false, session.Connection, null); } } public class PatientMap : ClassMap&lt;Patient&gt; { public PatientMap() { Id(x =&gt; x.Id); Map(x =&gt; x.Name) .Length(16) .Not.Nullable(); Map(x =&gt; x.Sex); Map(x =&gt; x.DateAdded); Map(x =&gt; x.AdmitDate); } } public class Patient { public virtual int Id { get; set; } public virtual string Name { get; set; } public virtual Gender Sex { get; set; } public virtual DateTimeOffset DateAdded { get; set; } public virtual DateTime? AdmitDate { get; set; } } public enum Gender { Male, Female } public class ExtendedLinqtoHqlGeneratorsRegistry : DefaultLinqToHqlGeneratorsRegistry { public ExtendedLinqtoHqlGeneratorsRegistry() { this.Merge(new AddDaysGenerator()); } } public class AddDaysGenerator : BaseHqlGeneratorForMethod { public AddDaysGenerator() { SupportedMethods = new[] { ReflectionHelper.GetMethodDefinition&lt;DateTimeOffset?&gt;(d =&gt; d.Value.AddDays((double)0)) }; } public override HqlTreeNode BuildHql(MethodInfo method, Expression targetObject, ReadOnlyCollection&lt;Expression&gt; arguments, HqlTreeBuilder treeBuilder, IHqlExpressionVisitor visitor) { return treeBuilder.MethodCall("AddDays", visitor.Visit(targetObject).AsExpression(), visitor.Visit(arguments[0]).AsExpression() ); } } public class CustomDialect : MsSql2008Dialect { public CustomDialect() { RegisterFunction( "AddDays", new SQLFunctionTemplate( NHibernateUtil.DateTime, "dateadd(day,?2,?1)" ) ); } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. PONhibernate LINQ DateTime.AddDay does not work
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJoel
    1. USvikram nayak
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PONhibernate LINQ DateTime.AddDay does not work
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COHello... How can I do that with embedded NHibernate mapping by code config?
      singulars
      1. PO
      1. USJunior
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload