Devart Forums

Release time?

e.g.
var employee=from _employee in _db.Employes
where _employee.birthay.value＝＝null
select _employee;
The above statement when the program stops responding when VS.NET.
----------------------------------
The following fragment can run:
var employee=from _employee in _db.Employes
where _employee.birthay.value.ToString()＝＝null
select _employee;

thank you

Datacontext.ExecuteQuery() and ExecuteCommand not work?

e.g
TestDataContext _db=new TestDataContext;
IEnumerable depts=_db.ExecuteQuery("select * from Dept",null);
ERROR:
NOT SUPPETED METHODS!
WHY?
HOW DO I get hold of command Query?

ExecuteCommand not work?

help me!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

But Linq to Oracle Beta 1.0.0.2 Is also supported by theby the

Oh! Forgot to say is: It is because you are the company's products in the Chinese and ASCII do not need to convert the area to support (such as the use of OracleTableAdapter for CURD operation of convenience, we have to buy your products, and is ready to buy Mission for the development of the commercial version, but now the company's managers are not satisfied with this, I hope you will be able to solve this problem as soon as possible.
Thanks very much!!!

Why is the use of the table adapter CURD operation will be no problem in the same environment?
I suspect that the problem is CoreLab.Data.EntityClient.dll

How should I do to avoid such problems? For example, please?

I am your business users.

my oradirect.net version 4.75.43
oracle :9.2.0.6
NLS_LANG:AMERICAN_AMERICA.US7ASCII
code:
QEntities db = new QEntities();
SDS_DM_WSZT dt = SDS_DM_WSZT.CreateSDS_DM_WSZT("98", "王明俊 ", "Y", "Y");
db.AddToSDS_DM_WSZT(dt);
db.SaveChanges();
errorCode:
Ora-01480:
{"ORA-01480: trailing null missing from STR bind value"}
But
List ws=(from wszt in db.SDS_DM_WSZT select wszt).ToList{};
DataView1.DatoSource=ws;
Display China is good!
-----------------
how do i?

var kz=(from kzs in _db.KZ
where kzs.firstname=="wangmjj"
order by kzs.firstname
select kzs).Last();
?????

SQL tracker :
EDM Wizard generate script:

SELECT "Project1".C1 AS C1,
"Project1"."CatalogName" AS "CatalogName",
"Project1"."SchemaName" AS "SchemaName",
"Project1"."Name" AS "Name"
FROM (SELECT "Extent1"."CatalogName" AS "CatalogName",
"Extent1"."SchemaName" AS "SchemaName",
"Extent1"."Name" AS "Name",
1 AS C1
FROM (
/*STables {C996CB0C-E37A-4f55-88AD-181F1989094D} {BFD32F32-EEE4-4826-9725-C489B0EE1ACC}*/
SELECT T."Id", T."CatalogName", T."SchemaName", T."Name"
FROM (SELECT AT.OWNER || '.' || AT.TABLE_NAME AS "Id",
'Catalog1' AS "CatalogName",
AT.OWNER AS "SchemaName",
AT.TABLE_NAME AS "Name"
/*Ora10gQuery
, AT.DROPPED
*/
FROM SYS.ALL_TABLES AT
UNION ALL
SELECT AOT.OWNER || '.' || AOT.TABLE_NAME AS "Id",
'Catalog1' AS "CatalogName",
AOT.OWNER AS "SchemaName",
AOT.TABLE_NAME AS "Name"
/*Ora10gQuery
, AOT.DROPPED
*/
FROM SYS.ALL_OBJECT_TABLES AOT) T
LEFT OUTER JOIN USER_TAB_PRIVS P ON (T."SchemaName" =
P.OWNER AND
P.GRANTEE = USER AND
P.TABLE_NAME = T."Name" AND
(P."PRIVILEGE" =
'SELECT' OR P."PRIVILEGE" =
'EXECUTE'))
WHERE (T."SchemaName" = USER OR P.GRANTEE = USER)
/*Ora10gQuery
AND T.DROPPED != 'YES'
*/
ORDER BY 3, 1) "Extent1") "Project1"
ORDER BY 3, 4
==============
But Oracle 9.2.0.1 Bug
"Not support "LEFT OUTER JOIN...." taxeme.
Install oracle_p3948480_9206_WINNT patch
ok!
Thank all with help me

when i Clieck "Next" after delay pop-up "Execate data defineORA-03313: END-OF-FILE....." at EDM Wizard.
if use LINQ To Oracle Beta is fine!
but it need OraDirect.net Version:4.75.23.

i have Test in other Oracle Server arisen alike problem!
My OS:windows Server 2003 sp1(language Chinse)
Oracle 9.2
help me! thanks!

ERROR Message:
System.Data.EntityCommandExecutionException
Type:CoreLab.Oracle.OracleException
ErrorMessage:
ORA-03313:end-of-file on communication channel
---------------------
but use 4.70.36 is fine and change .edmx file at node "<Schema.. Provider="CoreLab.Oracle.Entity" TO "CoreLab.Oracle" is ok!
----------------------
other:
server Resource Manager connection to Oracle is fine;
Creater DataTableAdapter is fine;
My OS:WINDOWS XP
Oracle:9i
vs.net 2008
all lanage:China simplified character

ERROR Message:
System.Data.EntityCommandExecutionException
Type:CoreLab.Oracle.OracleException
ErrorMessage:
ORA-03313:end-of-file on communication channel
---------------------
but use 4.70.36 is fine and change .edmx file at node "<Schema.. Provider="CoreLab.Oracle.Entity" TO "CoreLab.Oracle" is ok!
----------------------
other:
server Resource Manager connection to Oracle is fine;
Creater DataTableAdapter is fine;
My OS:WINDOWS XP
Oracle:9i
vs.net 2008
all lanage:China simplified character