unsigned data types not supported

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
vbo
Posts: 3
Joined: Fri 30 Nov 2018 14:17

unsigned data types not supported

Post by vbo » Fri 30 Nov 2018 14:26

Im get System.NotSupportedException when i try map an ushort (or uint) column.

Short sample:

create table x(
f number(5)
)

C# code

Code: Select all

class TableX
{
	public ushort f { get; set; }
}

....

ushort prm = 10;

r = db.X
	.Where(x => x.f == prm)
        .ToList();

as result
System.NotSupportedException: 'Not supported type 'System.UInt16' of the parameter '__prm_0'.'

How i can solve thir error?

vbo
Posts: 3
Joined: Fri 30 Nov 2018 14:17

Re: unsigned data types not supported

Post by vbo » Mon 03 Dec 2018 08:42

mitchelstarc wrote:
Fri 30 Nov 2018 19:33
I have read thet there is no need to mention the data type in the java programming. The code i think is correct you can check for a solution unrelated link I have got all the solution of c++ from here.
link is unrechable. And it's no Java or C++, I have a lot of tables than store unsigned numeric data. But i can't query this data with Devart.

Shalex
Site Admin
Posts: 8418
Joined: Thu 14 Aug 2008 12:44

Re: unsigned data types not supported

Post by Shalex » Wed 05 Dec 2018 13:00

vbo wrote:
Mon 03 Dec 2018 08:42
mitchelstarc wrote:
Fri 30 Nov 2018 19:33
I have read thet there is no need to mention the data type in the java programming. The code i think is correct you can check for a solution unrelated link I have got all the solution of c++ from here.
link is unrechable. And it's no Java or C++, I have a lot of tables than store unsigned numeric data. But i can't query this data with Devart.
1. Sorry, that is a spam.
vbo wrote:
Fri 30 Nov 2018 14:26
Im get System.NotSupportedException when i try map an ushort (or uint) column.
2. The unsigned types ushort and uint are not supported by Entity Framework: https://docs.microsoft.com/en-us/dotnet ... data-types.

vbo
Posts: 3
Joined: Fri 30 Nov 2018 14:17

Re: unsigned data types not supported

Post by vbo » Fri 07 Dec 2018 09:00

Shalex wrote:
Wed 05 Dec 2018 13:00
2. The unsigned types ushort and uint are not supported by Entity Framework
Ok. But, model work ok with MsSql server + MS ADO driver ant this model don't work with Devart + Oracle.
I have software that have to work with MsSql and Oracle and i must compare both drivers.

Shalex
Site Admin
Posts: 8418
Joined: Thu 14 Aug 2008 12:44

Re: unsigned data types not supported

Post by Shalex » Fri 07 Dec 2018 18:21

1. Specify the version of your Entity Framework.

2. A small test project with the model that works with System.Data.SqlClient and fails with Devart.Data.Oracle will be appreciated. You can provide it via contact form.

Post Reply