Devart Forums

Code: Select all

<add name="Entities" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=Devart.Data.Oracle;provider connection string="User Id=XXXXX;Password=XXXXXX;Server=XXX.XXX.XXX.XXX;Unicode=True;Direct=True;Service Name=XXXXX;Persist Security Info=True"" providerName="System.Data.EntityClient" />

Code: Select all

static void Main(string[] args)
        {
            Console.WriteLine("START");

            //Context
            var context = new Entities();
            var sql = new StringBuilder("SELECT NAME FROM ONETABLE WHERE UPPER(NAME) LIKE :parameter");

            var parameters = new List<DbParameter>
                                 {
                                     new OracleParameter(){ParameterName = "parameter", Value = "%" + "fails with ñ".ToUpper() + "%"}
                                 };

            var sqlResult = context.ExecuteStoreQuery<string>(sql.ToString(), parameters.ToArray());
            foreach (var item in sqlResult)
            {
                Console.WriteLine(item);
            }
            
            Console.WriteLine("END");
            Console.ReadLine();
        }

Code: Select all

Devart.Data.Oracle.OracleException was unhandled
Message=ORA-01460: unimplemented or unreasonable conversion requested
Source=Devart.Data.Oracle
ErrorCode=-2147467259
Code=1460
Offset=17
StackTrace:
at Devart.Data.Oracle.t.d()
at Devart.Data.Oracle.aq.h()
at Devart.Data.Oracle.aq.c()
at Devart.Data.Oracle.aa.a(Int32 A_0, bt 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.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteReader()
at System.Data.Objects.ObjectContext.ExecuteStoreQueryInternal[TElement](String commandText, String entitySetName, MergeOption mergeOption, Object[] parameters)
at System.Data.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, Object[] parameters)
at TestSql.ProgramSummary.Main(String[] args) in C:\TestSql\TestSql\ProgramSummary.cs:line 26
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: 

Code: Select all

using Devart.Data.Oracle;

namespace MonoOracleBenchmark
{
	class Program
	{
		static void Main()
		{
			const string connectionString = "Data Source=localhost;Persist Security Info=True;SID=XE;User ID=XXX;Password=XXX;"
				+ "Direct=True;Unicode=True;";
			var query = "select u.last_name from \"user_data\" u where u.last_name=:p0";
			// If I pass the same condition in query (without a parameter) as below, everything works fine.
			//query = "select u.last_name from \"user_data\" u where u.last_name='Użytkownik'";

			using (var oracleConnection = new OracleConnection(connectionString))
			{
				using (var command = oracleConnection.CreateCommand())
				{
					command.CommandText = query;
					command.Parameters.Add("p0", "Użytkownik");

					oracleConnection.Open();

					using (var reader = command.ExecuteReader())
					{
						while (reader.Read())
							System.Console.WriteLine(reader.GetValue(0));
						reader.Close();
					}
				}
				oracleConnection.Close();
			}
		}
	}
}