I am using llblgen trial version v2.6 Demo with Oracle 10g Express Database.
The following is the code snippet
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using xxx.DataEntity.EntityClasses;
using xxx.DataEntity.DatabaseSpecific;
using SD.LLBLGen.Pro.ORMSupportClasses;
using xxx.DataEntity.HelperClasses;
using xxx.DataEntity.FactoryClasses;
using xxx.ExceptionHandling;
namespace xxx.BusinessLayer.CaseNotes
{
public class CaseNotes
{
public DataTable GetCaseNotesForCase(int CaseId)
{
DataAccessAdapter adapter = new DataAccessAdapter();
DataTable dynamicList = new DataTable();
ResultsetFields fields = new ResultsetFields(2);
try
{
fields.DefineField(GvsStandardNotesFields.NoteType, 0, "NoteType");
fields.DefineField(GvsStandardNotesFields.NoteDescription, 1, "NoteDescription");
adapter.FetchTypedList(fields, dynamicList, null, 0, null, true, null); }
catch (Exception ex)
{ ..........}
return dynamicList;
}
}
}
I am getting an error on the adapter.FetchTypedList line.
Error:
Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
I have the Oracle.DataAccess, Version=2.102.2.20 in the bin/debug folder of
DataEntity.DatabaseSpecific project.
Stack Trace:
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause, Int32 pageNumber, Int32 pageSize)
at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchTypedList(IEntityFields2 fieldCollectionToFetch, DataTable dataTableToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, Boolean allowDuplicates, IGroupByCollection groupByClause)
at xxx.BusinessLayer.CaseNotes.CaseNotes.GetCaseNotesForCase(Int32 CaseId) in C:\GVS\BusinessLayer\CaseNotes\CaseNotes.cs:line 30
