Devart Forums

Hi again!!

I have a seconde question for you, i'm trying to use a datetime field in ESQL, but i could not do it!!

I don?t know how I have to implement this issue.

thanks!!
________
Wiki Vaporizer

Hi,

I would like to use .Include clausule in ESQL sentence, is posible?, something like that:

SELECT VALUE MYTABLE
FROM MYMODEL.MYTABLE.Include("MYTABLE")

thanks,
________
ALCOHOL REHAB DICUSSION

Hi, i'm using eSQL and i have a question

1.- ?Is possible use NULL value?

Can you show me an example?


thank,
________
Vapor Genie Vaporizer

Hi Andrey
I sent the script to your email.
Thanks
________
Hot Box Vaporizers

hi,


We have problems with ESQL queries to view. It gives error when generating a query that uses a LIKE and ORDER BY with LIMIT and SKIP. We realized that the error occurs when applying to LIKE NOT NULL fields.

SELECT VALUE VCLIENTESBUSQUEDA FROM ModeloCliente.VCLIENTESBUSQUEDA as VCLIENTESBUSQUEDA
WHERE VCLIENTESBUSQUEDA.CODCLIENTE LIKE @valor0
ORDER BY VCLIENTESBUSQUEDA.CODCLIENTE ASC SKIP @skip LIMIT @limit

@valor0= cv003%


best regards,
________
Mexico Hotels

I sent an email

thanks,
________
Zx14 vs hayabusa

Hi,

I have installed de latest version (5.25) of DotConnect for oracle, when i try to referesh my model i received this error:

Error 2054: A FunctionImport is mapped to a storage function

if i do the same action with the 5.20.33 version all works fine.

thanks,
________
XL175

Hi Andrey,

When is this new version be available??

With this new build can I insert rows using linq and modify them using function imports???

thanks,
________
ZX14 VS HAYABUSA

Hi Andrey,

I try to call Context.Connection.EnlistTransaction() method, but EnlistTransaction needs 1 argument Transaction and TransactionScope is not valid.

My code:

using (cnnEF Context = new cnnEF())
{
Context.Connection.Open();
using (TransactionScope tran = new TransactionScope())
{
Context.Connection.EnlistTransaction();
List lst = Context.GETPRUEBA(null).ToList();
________
Buy marijuana seeds

Hi Andrey,

When I put the Context.Connection.Open() method call inside the TransactionScope using block: ERROR

ORA-24756: la transacci?n no existe

My code:

using (cnnEF Context = new cnnEF())
{
using (TransactionScope tran = new TransactionScope())
{
Context.Connection.Open();
List lst = Context.GETPRUEBA(null).ToList();
________
No2 vaporizer

Hi Andrey,

It doesn't work. I need to combine in 1 connection function imports with LINQ , ?it's possible with devart dotConnect for oracle?
________
Lamborghini Countach Specifications

Hi,

Anything new on this subject?
________
VAPIR NO2

Hi,
I'm trying to use TransactionScope:

case 1: Not found
using (miContexto Context = new miContexto())
{
using (TransactionScope tran = new TransactionScope())
{

//step1 : this function returns a code
string strAux = Context.F_Import1(null,"a").ToList()[0].codigo;
//step2 : insert many rows in Table1 table
foreach(string str2 in lineas)
{
Table1 aux = new Table1();
aux.Nombre = str2;
aux.cod = strAux;
Context.AddTable1(aux);
}

Context.SaveChanges(false );

//step 3: this function uses the rows that are inserted in step 2, but it doesn't find data
string strAux2 = Context.F_Import2(null,"a").ToList()[0].codigo;

tran.Complete();
Context.AcceptAllChanges();

}
}

case 2: found ok (it hasn't transaction control)

using (miContexto Context = new miContexto())
{


string strAux = Context.F_Import1(null,"a").ToList()[0].codigo;

foreach(string str2 in lineas)
{
Table1 aux = new Table1();
aux.Nombre = str2;
aux.cod = strAux;
Context.AddTable1(aux);
}

Context.SaveChanges();

string strAux2 = Context.F_Import2(null,"a").ToList()[0].codigo;
}
}
________
COCAINE REHAB ADVICE

Sorry, is right!!!
________
Stranger Originated Life Insurance Advice

Can you show an example please?

thanks,
________
FREE GIFT CARDS