ORA-01747: invalid user.table.column, table.column, or column specification
ORA-01747: invalid user.table.column, table.column, or column specification
Hi,
We are using .netCore Entityframework (Code First).
1) We migrate database using -update-database command working fine.
but we don't want to case sensitivity in oracle, Thats why we use config.Workarounds.DisableQuoting = true;
2) After applying this given error occured in following code block.
var query = _ClientRepository.GetAll()
.WhereIf(!input.Filter.IsNullOrWhiteSpace(),
u =>
u.Name.Contains(input.Filter) ||
u.Surname.Contains(input.Filter)
);
var Pagedcount = await query.CountAsync();
var Client = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
Thanks.
We are using .netCore Entityframework (Code First).
1) We migrate database using -update-database command working fine.
but we don't want to case sensitivity in oracle, Thats why we use config.Workarounds.DisableQuoting = true;
2) After applying this given error occured in following code block.
var query = _ClientRepository.GetAll()
.WhereIf(!input.Filter.IsNullOrWhiteSpace(),
u =>
u.Name.Contains(input.Filter) ||
u.Surname.Contains(input.Filter)
);
var Pagedcount = await query.CountAsync();
var Client = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
Thanks.
Re: ORA-01747: invalid user.table.column, table.column, or column specification
Hi,
We Extract Query Created by this block of code:
ORA-01747: invalid user.table.column, table.column, or column specification
We Extract Query Created by this block of code:
Code: Select all
var Client = await query
.OrderBy(input.Sorting)
.PageBy(input)
.ToListAsync();
And this query return Error:SELECT t.Id, t.CreationTime, t.CreatorUserId, t.DOB, t.DeleterUserId, t.DeletionTime, t.EmailAddress, t.IsDeleted, t.LastModificationTime, t.LastModifierUserId, t.Mobile, t.Name, t.Surname
FROM (
SELECT e.Id, e.CreationTime, e.CreatorUserId, e.DOB, e.DeleterUserId, e.DeletionTime, e.EmailAddress, e.IsDeleted,
e.LastModificationTime, e.LastModifierUserId, e.Mobile, e.Name, e.Surname, ROWNUM
FROM Client e
WHERE e.IsDeleted = 0
ORDER BY e.Name
) t
WHERE (t.ROWNUM > :p__p_0) AND (t.ROWNUM <= (:p__p_0 + :p__p_1))
ORA-01747: invalid user.table.column, table.column, or column specification
Re: ORA-01747: invalid user.table.column, table.column, or column specification
Its not clear how your repository is implemented. Please upload a small test project with the corresponding DDL script to ftp://ftp.devart.com (credentials: anonymous / yourEmail).
Re: ORA-01747: invalid user.table.column, table.column, or column specification
Hi,
We are make some changes in Query, Its working.
We are sending application on given FTP.
Thanks.
We are make some changes in Query, Its working.
Code: Select all
SELECT t.Id, t.CreationTime, t.CreatorUserId, t.DOB, t.DeleterUserId, t.DeletionTime, t.EmailAddress, t.IsDeleted, t.LastModificationTime, t.LastModifierUserId, t.Mobile, t.Name, t.Surname
FROM (
SELECT e.Id, e.CreationTime, e.CreatorUserId, e.DOB, e.DeleterUserId, e.DeletionTime, e.EmailAddress, e.IsDeleted,
e.LastModificationTime, e.LastModifierUserId, e.Mobile, e.Name, e.Surname, ROWNUM R
FROM Client e
WHERE e.IsDeleted = 0
ORDER BY e.Name
) t
WHERE (t.R > 0) AND (t.R <= (0 + 1))
Thanks.
Re: ORA-01747: invalid user.table.column, table.column, or column specification
Thank you for the test project. We have reproduced the problem and are investigating it. We will notify you about the result as soon as possible.
Re: ORA-01747: invalid user.table.column, table.column, or column specification
HI,
We are waiting for your reply.
Thanks.
We are waiting for your reply.
Thanks.
Re: ORA-01747: invalid user.table.column, table.column, or column specification
The bug with throwing ORA-01747 by LINQ query in EF Core is fixed. We will notify you when the new public version is available. A current workaround is provided by email.
Re: ORA-01747: invalid user.table.column, table.column, or column specification
New build of dotConnect for Oracle 9.4.348 is available for download now: viewtopic.php?f=1&t=35921.