Sure. Everytime I want to add a new table, I get the following error:
NHibernate.Exceptions.GenericADOException occurred
HResult=0x80131600
Message=could not execute query
[ select dcsv0_.id as id3_, dcsv0_.fnaam as fnaam3_, dcsv0_.fvolgorde as
fvolgorde3_, dcsv0_.ftype as ftype3_, dcsv0_.fglobal as fglobal3_,
dcsv0_.fmachine as fmachine3_, dcsv0_.fparameter as fparameter3_ from DCSV
dcsv0_ ]
[SQL: select dcsv0_.id as id3_, dcsv0_.fnaam as fnaam3_, dcsv0_.fvolgorde
as fvolgorde3_, dcsv0_.ftype as ftype3_, dcsv0_.fglobal as fglobal3_,
dcsv0_.fmachine as fmachine3_, dcsv0_.fparameter as fparameter3_ from DCSV
dcsv0_]
Source=NHibernate
StackTrace:
at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
QueryParameters queryParameters, IResultTransformer forcedResultTransformer)
at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor
session, QueryParameters queryParameters)
at NHibernate.Loader.Loader.List(ISessionImplementor session,
QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
at NHibernate.Loader.Hql.QueryLoader.List(ISessionImplementor session,
QueryParameters queryParameters)
at NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor
session, QueryParameters queryParameters)
at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters
queryParameters, ISessionImplementor session, IList results)
at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression,
QueryParameters queryParameters, IList results)
at NHibernate.Impl.AbstractSessionImpl.List(IQueryExpression
queryExpression, QueryParameters parameters)
at NHibernate.Impl.AbstractQueryImpl2.List()
at NHibernate.Linq.DefaultQueryProvider.ExecuteQuery(NhLinqExpression
nhLinqExpression, IQuery query, NhLinqExpression nhQuery)
at NHibernate.Linq.DefaultQueryProvider.Execute(Expression expression)
at NHibernate.Linq.DefaultQueryProvider.Execute[TResult](Expression
expression)
at Remotion.Linq.QueryableBase`1.GetEnumerator()
at NHDataCore.NHTable`1.<AsEnumerable>d__14.MoveNext() in
E:\Documenten\Weighpack\New Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\NHDataCore\NHDataCore\NHTable.cs:line
172
at OMS2.Model.CSVs.refresh() in E:\Documenten\Weighpack\New Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\CSVs.cs:line
39
at OMS2.Model.CSVs..ctor(DataModel AModel) in
E:\Documenten\Weighpack\New Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\CSVs.cs:line
32
at OMS2.Model.DataModel.LoadAllData() in E:\Documenten\Weighpack\New
Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\DataModel.cs:line
156
at OMS2.Model.DataModel..ctor() in E:\Documenten\Weighpack\New Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\Model\DataModel.cs:line
128
at OMS2.MainWindow.InitializeOMS() in E:\Documenten\Weighpack\New
Database
3\OMS-Development-3718907727c4a695ff28360f4d3e9ea946495840\OMS2\MainWindow.xaml.cs:line
69
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate
callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source,
Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
The code for adding the new table in the database is:
using NHDataCore;
using FluentNHibernate.Mapping;
namespace OMS2.Model.Entities
{
public class DCSV : NHRow
{
[Indexed]
public virtual string naam { get; set; }
public virtual int volgorde { get; set; }
public virtual string type { get; set; }
public virtual string global { get; set; }
public virtual string machine { get; set; }
public virtual string parameter { get; set; }
}
public class DCSVMap : ClassMap<DCSV>
{
public DCSVMap()
{
Table("DCSV");
Cache.NonStrictReadWrite();
Id(x => x.id).GeneratedBy.Native();
Map(x => x.naam, "fnaam");
Map(x => x.volgorde, "fvolgorde");
Map(x => x.type, "ftype");
Map(x => x.global, "fglobal");
Map(x => x.machine, "fmachine");
Map(x => x.parameter, "fparameter");
}
}
}
When I remove everything under public class DCSVMap : ClassMap<DCSV>, the
code will run. But when I add it again, the previous error occurs.
I can copy the query and try to execute it in the database, but I don't
know how to do that.
Op donderdag 10 augustus 2017 23:55:27 UTC+2 schreef Gunnar Liljas:
>
> Is it an NHibernate issue?
>
> Can you be more specific?
>
> /g
>
> On 10 Aug 2017, at 20:03, Ganesh Gebhard <[email protected]
> <javascript:>> wrote:
>
> Hi,
>
> I tried to add a new table to the sql database, but it gives an error no
> matter what I do.
>
> So, what are the steps to add a new table to the sql database?
>
> Thanks in advance.
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> To post to this group, send email to [email protected] <javascript:>
> .
> Visit this group at https://groups.google.com/group/nhusers.
> For more options, visit https://groups.google.com/d/optout.
>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
