After some work I was able to get the test code to drop and generate a test database every time. I can insert a row. But on a simple query:
Code: Select all
public V_ZIPCODELONGLAT GetZipCenter(String zip)
{
return _Db.V_ZIPCODELONGLAT.Where(a => a.ZCLL_ZIPCODE == zip).FirstOrDefault();
}
The actual sql looks like this:An error occurred while executing the command definition. See the inner exception for details. ---> Devart.Data.Oracle.OracleException: ORA-31046: TT2777: Argument of unary operation cannot be parameter with undefined type; please use CAST operator to define a data type for parameter -- file "saCanon.c", lineno 25235, procedure "inferExprTN()"
Result StackTrace:
at Devart.Data.Oracle.a1.c(Int32 A_0)
at Devart.Data.Oracle.cs.a(Int32 A_0, cc A_1)
at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Data.Oracle.Entity.h.a(CommandBehavior A_0)
at Devart.Common.Entity.ck.b(CommandBehavior A_0)
at Devart.Data.Oracle.Entity.h.b(CommandBehavior A_0)
at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TInterceptionContext,TResult](Func`1 operation, TInterceptionContext interceptionContext, Action`1 executing, Action`1 executed)
at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)
at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)
Code: Select all
SELECT "Extent1".ZCLL_ZIPCODE, "Extent1".ZCLL_RADLONG, "Extent1".ZCLL_RADLAT
FROM V_ZIPCODELONGLAT "Extent1"
WHERE (("Extent1".ZCLL_ZIPCODE = :p__linq__0) AND (:p__linq__0 IS NOT NULL)) AND ROWNUM <= 1