Hello,
I have just upgraded NHIbernate and Fluent to the latest versions (NH to
3.3.1.4000 and Fluent to 1.3.0.733) and my working solution has stop
working with certain objects with the following error.
{System.IndexOutOfRangeException: Invalid index 3 for this
SqlParameterCollection with Count=3.
at System.Data.SqlClient.SqlParameterCollection.RangeCheck(Int32 index)
at System.Data.SqlClient.SqlParameterCollection.GetParameter(Int32 index)
at
System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(Int32
index)
at NHibernate.Type.Int32Type.Set(IDbCommand rs, Object value, Int32
index)
at NHibernate.Type.NullableType.NullSafeSet(IDbCommand cmd, Object
value, Int32 index)
at NHibernate.Type.NullableType.NullSafeSet(IDbCommand st, Object value,
Int32 index, ISessionImplementor session)
at NHibernate.Param.NamedParameterSpecification.Bind(IDbCommand command,
IList`1 multiSqlQueryParametersList, Int32 singleSqlParametersOffset,
IList`1 sqlQueryParametersList, QueryParameters queryParameters,
ISessionImplementor session)
at NHibernate.Param.NamedParameterSpecification.Bind(IDbCommand command,
IList`1 sqlQueryParametersList, QueryParameters queryParameters,
ISessionImplementor session)
at NHibernate.SqlCommand.SqlCommandImpl.Bind(IDbCommand command,
ISessionImplementor session)
at NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters
queryParameters, Boolean scroll, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
QueryParameters queryParameters, Boolean returnProxies)
at
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor
session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters)}
What its weird to me is that this was working perfectly.
The object is as follows.
[DataContract(IsReference = true)]
[KnownType(typeof(Categoria))]
[KnownType(typeof(Comentario))]
public partial class Noticia
{
[DataMember]
public virtual long Id { get; set; }
[DataMember]
public virtual string Asunto { get; set; }
[DataMember]
public virtual string Intro { get; set; }
[DataMember]
public virtual string Texto { get; set; }
[DataMember]
public virtual bool Publicar { get; set; }
[DataMember]
public virtual Categoria Categoria { get; set; }
[DataMember]
public virtual Producto Producto { get; set; }
[DataMember]
public virtual Empresa Empresa { get; set; }
[DataMember]
public virtual IList<Comentario> Comentario { get; set; }
[DataMember]
public virtual bool Frontpage { get; set; }
[DataMember]
public virtual int? FrontpagePosition { get; set; }
[DataMember]
public virtual string Tags { get; set; }
[DataMember]
public virtual Usuario Creador { get; set; }
[DataMember]
public virtual DateTime FechaAlta { get; set; }
}
Mapping:
public partial class NoticiaMap: ClassMap<Noticia>
{
public NoticiaMap()
{
//Table("NoticiaSet");
Id(x => x.Id).GeneratedBy.Identity();
HasMany(x => x.Comentario).LazyLoad().Inverse().Cascade.All();
References(x => x.Categoria).Nullable();
References(x => x.Empresa).Nullable();
References(x => x.Producto).Nullable();
Map(x => x.Publicar).Not.Nullable();
Map(x => x.Asunto).Length(512).Not.Nullable();
Map(x => x.Intro).Length(1024).Nullable();
Map(x =>
x.Texto).CustomType("StringClob").CustomSqlType("nvarchar(max)").Not.Nullable();
Map(x => x.FechaAlta).Not.Nullable();
Map(x => x.Frontpage).Not.Nullable().Default("0");
Map(x => x.FrontpagePosition).Nullable();
Map(x => x.Tags).Length(512).Nullable();
References(x => x.Creador).Not.Nullable();
}
}
Code Failing:
@foreach (var item in Model)
{
<div class="row">
<div style="text-align:center;" class="one
columns">@item.Publicar.ToString()</div>
<div style="text-align:center;" class="one
columns">@item.Frontpage</div>
<div style="text-align:center;" class="one
columns">@item.FrontpagePosition</div>
<div style="text-align:center;" class="three
columns">@item.Asunto</div>
<div style="text-align:center;" class="one columns">
@if (item.Categoria != null) {
@item.Categoria.Nombre }
@if (item.Empresa != null) {
@item.Empresa.Nombre }
@if (item.Producto != null) {
@item.Producto.Nombre }
</div>
<div style="text-align:center;" class="one
columns">@item.Creador.Nombre</div>
<div style="text-align:center;" class="one
columns">@item.FechaAlta.ToShortDateString()</div>
<div style="text-align:center;" class="three
columns">
<a href="#"
onclick="javascript:SourceInjector('#Content', '@Url.Action("Modificar",
"Noticia", new { id = item.Id })')">Modificar</a> ||
@Ajax.ActionLink("Eliminar", "Eliminar",
"Noticia", new { id = item.Id }, new AjaxOptions { Confirm = "¿Eliminar Noticia
" + item.Asunto + "?", HttpMethod = "Post", UpdateTargetId = "Content" }, null)
||
<a href="@Url.Action(item.Id.ToString(),
"Articulo")" target="_blank">Preview</a>
</div>
</div>
}
As soon as it goes into the foreach it fails. What baffles me is that this was
working before.
Any help welcomed.
-Cheers,
Fabricio
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/nhusers/-/gy-JRfGNdaoJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
