Fluent Nhibernate Issues Mapping MySQL Time (6) to C # DateTime

I have a MySql table with the following schema

Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment Date date YES MUL NULL Time time(6) NO MUL NULL Exch varchar(45) YES MUL NULL ProdType varchar(45) YES NULL Product varchar(45) YES NULL Contract varchar(45) YES NULL Direction varchar(45) YES NULL Price decimal(10,4) YES NULL Quantity int(11) YES NULL 

Free model:

 public class Trade { public virtual int Id { get; set; } public virtual DateTime Date { get; set; } public virtual DateTime Time { get; set; } public virtual string Contract { get; set; } public virtual string Direction { get; set; } public virtual double Price { get; set; } public virtual int Quantity { get; set; } } 

and display:

 public TradeMap() { Id(x => x.Id).Column("id"); Map(x => x.Date).Column("Date"); Map(x => x.Time).Column("Time").CustomType("timestamp");; Map(x => x.Contract).Column("Contract"); Map(x => x.Direction).Column("Direction"); Map(x => x.Price).Column("Price"); Map(x => x.Quantity).Column("Quantity"); Table("ts"); } 

I am testing ORM with the following code

  DateTime dayStart = Convert.ToDateTime("11:31:00.000000"); DateTime dayEnd = Convert.ToDateTime("11:32:00.000000"); IQueryable<Trade> result = from ts in repo.GetList<Trade>() where ts.Date == new DateTime(2013,7,1) && ts.Time >= dayStart && ts.Time <= dayEnd && ts.Contract == "Sep13" select ts; foreach (var l in result) { DateTime k = l.Time; } 

and

 Trade result = repo.GetList<Trade>().FirstOrDefault(); 

But I keep getting an internal exception

 {"Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'."} 

I tried to resolve this by changing the time display to

 Map(x => x.Time).Column("tsTime").CustomType("timestamp").CustomSqlType("TIME(6)").Nullable(); 

Map (x => x.Time) .Column ("tsTime"). CustomSqlType ("TIME (6)");

but nothing works

+4
source share
1 answer

Use one field for DATE + TIME.

0
source

Source: https://habr.com/ru/post/1501361/


All Articles