Databases
StackOverflow2013
Postsdbo
POSystem.InvalidCastException: Invalid cast from 'DateTime' to 'Int32'. nhibernate
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSystem.InvalidCastException: Invalid cast from 'DateTime' to 'Int32'. nhibernate
    text
    copied!<p>I have the following classes:</p> <pre><code>public class AccionCorrectiva : Modelo&lt;AccionCorrectiva&gt; { ... public virtual DateTime FechaFin { get; set; } ... } public class Indicador : Modelo&lt;Indicador&gt; { private IList&lt;AccionCorrectiva&gt; _acciones = new List&lt;AccionCorrectiva&gt;(); public virtual IList&lt;AccionCorrectiva&gt; Acciones { get { return _acciones; } set { _acciones = value; } } } </code></pre> <p>When I do <code>SomeIndicador.Acciones</code> I get:</p> <p><code>NHibernate.Exceptions.GenericADOException: could not initialize a collection: [Dominio.Indicador.Acciones#1][SQL: SELECT acciones0_.indicador_id as indicador8_1_, acciones0_.Id as Id1_, acciones0_.FechaFin as FechaFin1_, acciones0_.Id as Id6_0_, acciones0_.Hallazgo as Hallazgo6_0_, acciones0_.Descripcion as Descripc3_6_0_, acciones0_.Objetivo as Objetivo6_0_, acciones0_.FechaFin as FechaFin6_0_, acciones0_.NumEstado as NumEstado6_0_, acciones0_.responsable_id as responsa7_6_0_, acciones0_.indicador_id as indicador8_6_0_ FROM acciones_correctivas acciones0_ WHERE acciones0_.indicador_id=?] ---&gt; System.FormatException: Input string '01/01/2013 0:00:00' was not in the correct format. ---&gt; System.InvalidCastException: Invalid cast from 'DateTime' to 'Int32'.</code></p> <p>What am I doing wrong?</p> <p><strong>EDIT</strong> If I call <code>AccionCorrectivaRepository.Instance.FindById(1)</code> I get an AccionCorrectiva and works fine! The dialect is SQLite</p> <p>Table structure:</p> <pre><code>CREATE TABLE acciones_correctivas (Id INT not null, FechaFin DATETIME); </code></pre> <p><strong>Mappings</strong> Indicador</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Dominio" namespace="Dominio"&gt; &lt;class name="Indicador" table="indicadores"&gt; &lt;id name="Id"&gt; &lt;generator class="increment" /&gt; &lt;/id&gt; &lt;list name="Acciones" cascade="all-delete-orphan"&gt; &lt;key column="indicador_id" /&gt; &lt;index column="FechaFin" /&gt; &lt;one-to-many class="AccionCorrectiva" /&gt; &lt;/list&gt; &lt;/class&gt; &lt;/hibernate-mapping&gt; </code></pre> <p>AccionCorrectiva:</p> <pre><code>&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="Dominio" namespace="Dominio"&gt; &lt;class name="AccionCorrectiva" table="acciones_correctivas"&gt; &lt;id name="Id"&gt; &lt;generator class="increment" /&gt; &lt;/id&gt; &lt;many-to-one name="Indicador" column="indicador_id" /&gt; &lt;/class&gt; &lt;/hibernate-mapping&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

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