Using VS 2005 VB.NET
At the first point in my new project when my app attempts some oracle access I get:
System.IO.FileNotFoundException was unhandled by user code
Message="Could not load file or assembly 'Oracle.DataAccess, Version=9.2.0.401, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified."
Source="SD.LLBLGen.Pro.DQE.Oracle.NET20"
StackTrace:
at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreateCommand()
at SD.LLBLGen.Pro.DQE.Oracle.DynamicQueryEngine.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause, Boolean relationsSpecified, Boolean sortClausesSpecified)
at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFieldCore[] selectList, IFieldPersistenceInfo[] fieldsPersistenceInfo, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause)
at SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.CreateSelectDQ(IEntityFields selectList, IDbConnection connectionToUse, IPredicate selectFilter, Int64 maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection relationsToWalk, Boolean allowDuplicates, IGroupByCollection groupByClause)
at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformFetchEntityAction(IEntity entityToFetch, ITransaction containingTransaction, IPredicateExpression selectFilter, IPrefetchPath prefetchPathToUse, Context contextToUse)
at SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.FetchExisting(IEntity entityToFetch, ITransaction containingTransaction, IPrefetchPath prefetchPathToUse, Context contextToUse)
at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.Fetch(String username,
IPrefetchPath prefetchPathToUse, Context contextToUse) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 884
at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.FetchUsingPK(String username, IPrefetchPath prefetchPathToUse, Context contextToUse) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 371
at Fluor.MatCert2.DAL.EntityClasses.AppUserEntityBase.FetchUsingPK(String username) in D:\Data\vss\MatCert2\MatCert2Solution\DAL\EntityBaseClasses\AppUserEntityBase.vb:line 354
at LoginCredentials..ctor(String pstrUsername, String PasswordAttempt) in d:\Data\vss\MatCert2\MatCert2Solution\MatCert2\App_Code\LoginCredentials.vb:line 83
at Login.cmdOK_Click(Object sender, EventArgs e) in d:\Data\vss\MatCert2\MatCert2Solution\MatCert2\Login.aspx.vb:line 129
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
''' <returns>True if succeeded, False otherwise.</returns>
Private Function Fetch(username As System.String, prefetchPathToUse As IPrefetchPath, contextToUse As Context) As Boolean
Try
OnFetch()
Dim dao As IDao = Me.CreateDAOInstance()
MyBase.Fields(CInt(AppUserFieldIndex.Username)).ForcedCurrentValueWrite(username)
error on this line-----> dao.FetchExisting(Me, MyBase.Transaction, prefetchPathToUse, contextToUse)
Dim fetchResult As Boolean = False
If MyBase.Fields.State = EntityState.Fetched Then
MyBase.IsNew = False
fetchResult = True
If Not contextToUse Is Nothing Then
MyBase.ActiveContext = contextToUse
Dim dummy As IEntity = contextToUse.Get(Me)
I have seen similar problems with setup projects mentioned. My
policy.9.2.Oracle.DataAccess.config file:
<configuration>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342"/>
<bindingRedirect oldVersion="9.2.0.000-9.2.0.999" newVersion="9.2.0.700"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
My setup:
Name: SelfServicing, two class scenario (Full / Safe) Vs.Net 2005
Version: 1.0.2005.1.10232005
Name: VB.NET template set for Oracle 8i/9i (1.0.2005.1)
Version: 1.0.2005.1.102305
Vendor: Solutions Design
Target language: VB.NET
SD.LLBLGen.Pro.DQE.Oracle.NET20.dll version: 1.0.20051.060305
Oracle Data Provider for .NET 9.2.0.7.0 installed.
I'm getting nowhere fast, can anyone help?
Help!
Graham