Hi
I used your example from
http://blog.cincura.net/231783-ultimate-efv4-ctp4-code-first-full-mapping-example-using-firebird/
and made a simple model, dbcontext and firebird database.
public class Drzava
{
public int Id {get; set; }
public string Oznaka { get; set; }
public string Naziv { get; set; }
public DateTime ZadnjaIzmena { get; set; }
public bool Aktivan { get; set; }
public bool IsEU { get; set; }
}
And the sql that is generated for the followin linq query is running fine
DateTime someDate = new DateTime(2000,1,1);
var drzave = from d in drzavaContext.Drzave where d.ZadnjaIzmena >
someDate select d;
SELECT
'0X0X' AS "C1",
"Extent1"."ID" AS "ID",
"Extent1"."AKTIVAN" AS "AKTIVAN",
"Extent1"."ISEU" AS "ISEU",
"Extent1"."NAZIV" AS "NAZIV",
"Extent1"."OZNAKA" AS "OZNAKA",
"Extent1"."ZADNJAIZMENA" AS "ZADNJAIZMENA"
FROM "DRZAVA" AS "Extent1"
WHERE "Extent1"."ZADNJAIZMENA" > @p__linq__0
Name:@p__linq__0 Type:TimeStamp Value:1.1.2000 0:00:00
I setup a silverlight application with RIA Services and made a simple
DomainContext that uses the above mentioned dbcontext.
Now if I try to run the linq query on the silverlight client the query
will look like this and fail becouse the datetime param isn't quoted:
SELECT
'0X0X' AS "C1",
"Extent1"."ID" AS "ID",
"Extent1"."AKTIVAN" AS "AKTIVAN",
"Extent1"."ISEU" AS "ISEU",
"Extent1"."NAZIV" AS "NAZIV",
"Extent1"."OZNAKA" AS "OZNAKA",
"Extent1"."ZADNJAIZMENA" AS "ZADNJAIZMENA"
FROM "DRZAVA" AS "Extent1"
WHERE "Extent1"."ZADNJAIZMENA" > 2000-01-01 00:00:00.000
So my question is what i'm doing wrong or why isn't the datetime param quoted?
Is there some workaround for this.
I was using the 2.6.0.0 firebird provider with Firebird 2.5.
Thx
------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
