The csdl from emdx, looks good to me.
Thanks,
John
<EntityType Name="OrderDetail" ib:Pname="s:OrderDetails">
<Key>
<PropertyRef Name="OrderID" />
<PropertyRef Name="ProductID" />
</Key>
<Property Name="OrderID" Type="Int32" Nullable="false" />
<Property Name="ProductID" Type="Int32" Nullable="false" />
<Property Name="UnitPrice" Type="Decimal" Precision="18" Scale="4" />
<Property Name="Quantity" Type="Int16" />
<Property Name="Discount" Type="Single" />
<NavigationProperty Name="Order"
Relationship="ServerModelNorthwind.model.FK_OrderDetails_1"
FromRole="OrderDetails" ToRole="Orders" ib:Pname="s:Orders" />
<NavigationProperty Name="Product"
Relationship="ServerModelNorthwind.model.FK_OrderDetails_2"
FromRole="OrderDetails" ToRole="Products" ib:Pname="s:Products" />
</EntityType>
On Apr 15, 2010, at 7:45 AM,
[email protected] wrote:
> Send Firebird-net-provider mailing list submissions to
> [email protected]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
> or, via email, send a message with subject or body 'help' to
> [email protected]
>
> You can reach the person managing the list at
> [email protected]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Firebird-net-provider digest..."
>
>
> Today's Topics:
>
> 1. Re: FirebirdSql.Data.Isql and newlines (G?bor T?r?k)
> 2. Re: FirebirdSql.Data.Isql and newlines (Jiri Cincura)
> 3. Named transactions (Ivan Arabadzhiev)
> 4. Help Using Linqpad (John Tomaselli)
> 5. Re: Help Using Linqpad (Jiri Cincura)
> 6. UTF-8 connection problem (Marcin Kacprzak)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Tue, 13 Apr 2010 17:43:33 +0200
> From: G?bor T?r?k <[email protected]>
> Subject: Re: [Firebird-net-provider] FirebirdSql.Data.Isql and
> newlines
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[email protected]>
> Content-Type: text/plain; charset=UTF-8
>
> On Thu, Mar 25, 2010 at 9:59 PM, Jiri Cincura <[email protected]> wrote:
>> Probably yes. The parsing there is limited. Please create an item in
>> tracker, I'll look at it.
>
> Thanks!
> I created a tracker item. I can look for a solution and provide a
> patch if you would like me to and if you decide whether to collapse
> whitespace in FbScript.Parse() or extend StringParser to support
> multiple separators.
>
>
>
> ------------------------------
>
> Message: 2
> Date: Tue, 13 Apr 2010 20:47:29 +0200
> From: Jiri Cincura <[email protected]>
> Subject: Re: [Firebird-net-provider] FirebirdSql.Data.Isql and
> newlines
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> 2010/4/13 G?bor T?r?k <[email protected]>:
>> I can look for a solution and provide a
>> patch if you would like me to and if you decide whether to collapse
>> whitespace in FbScript.Parse() or extend StringParser to support
>> multiple separators.
>
> Sure. Every help counts.
>
> --
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 14 Apr 2010 00:36:33 +0400
> From: "Ivan Arabadzhiev" <[email protected]>
> Subject: [Firebird-net-provider] Named transactions
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID: <op.va4ea90pb2p...@vostro-dwd>
> Content-Type: text/plain; charset=windows-1251; format=flowed;
> delsp=yes
>
> Hi,
> I just wanted to ask what`s the point (and possible use) of a named
> transaction.
>
> Actually, what I`m more interested in is if the provider has a way of
> starting "concurrent transactions" (last i checked it threw an exception).
> Will it handle them if I "name" them?
>
>
>
>
> --
> Sanity is a sin!
>
>
>
> ------------------------------
>
> Message: 4
> Date: Wed, 14 Apr 2010 23:21:30 -0400
> From: John Tomaselli <[email protected]>
> Subject: [Firebird-net-provider] Help Using Linqpad
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi,
> I'm using LINQPad & Entity Framework 3.5 with Firebird 2.5.2 and trying to
> learn Linq.
> I've converted the NorthwindEF.mdf database to Firebird 2.5 and I have a
> problem with the OrderDetail, UnitPrice (money) field. By definition the
> field is defined as decimal(18,4) which is the highest value allowed in
> firebird. When using the sample below an error is raised because the sql
> created uses a cast to decimal(19,0) (highlight in red). If I cut and paste
> in ibexpert
> and test with a change to (18,0) everything works. I wrote the author (Joe
> Albahari <[email protected]>) of linqpad http://www.linqpad.net/ and he
> suggested that it's a Firebird provider issue.
> TIA
> John
>
>
>
> Linq:
> from p in Products
> let spanishOrders = p.OrderDetails.Where (o => o.Order.ShipCountry ==
> "Spain")
> where spanishOrders.Any()
> orderby p.ProductName
> select new
> {
> p.ProductName,
>
> Orders = spanishOrders.Count(),
> TotalValue = spanishOrders.Sum (o =>o.UnitPrice * o.Quantity)
> }
> LinqPad
> Result:
> Fail: decimalPrecision must be less than or equal to 18
> Command:
> SELECT
> "Project4"."C1" AS "C1",
> "Project4"."ProductName" AS "ProductName",
> "Project4"."C2" AS "C2",
> "Project4"."C3" AS "C3"
> FROM ( SELECT
> "Project3"."ProductName" AS "ProductName",
> 1 AS "C1",
> "Project3"."C1" AS "C2",
> "Project3"."C2" AS "C3"
> FROM ( SELECT
> "Project2"."ProductName" AS "ProductName",
> "Project2"."C1" AS "C1",
> (SELECT
> Sum("Filter4"."A1") AS "A1"
> FROM ( SELECT
> "Extent6"."UnitPrice" *
> (CAST("Extent6"."Quantity" AS DECIMAL(19,0))) AS "A1"
> FROM "OrderDetails" AS "Extent6"
> INNER JOIN "Orders" AS "Extent7" ON
> "Extent6"."OrderID" = "Extent7"."OrderID"
> WHERE ("Project2"."ProductID" =
> "Extent6"."ProductID") AND (_UTF8'Spain' = "Extent7"."ShipCountry")
> ) AS "Filter4") AS "C2"
> FROM ( SELECT
> "Extent1"."ProductID" AS "ProductID",
> "Extent1"."ProductName" AS "ProductName",
> (SELECT
> Count("Filter3"."A1") AS "A1"
> FROM ( SELECT
> CAST(1 AS SMALLINT) AS "A1"
> FROM "OrderDetails" AS "Extent4"
> INNER JOIN "Orders" AS "Extent5" ON
> "Extent4"."OrderID" = "Extent5"."OrderID"
> WHERE ("Extent1"."ProductID" =
> "Extent4"."ProductID") AND (_UTF8'Spain' = "Extent5"."ShipCountry")
> ) AS "Filter3") AS "C1"
> FROM "Products" AS "Extent1"
> WHERE EXISTS (SELECT
> CAST(1 AS SMALLINT) AS "C1"
> FROM "OrderDetails" AS "Extent2"
> INNER JOIN "Orders" AS "Extent3" ON
> "Extent2"."OrderID" = "Extent3"."OrderID"
> WHERE ("Extent1"."ProductID" =
> "Extent2"."ProductID") AND (_UTF8'Spain' = "Extent3"."ShipCountry")
> )
> ) AS "Project2"
> ) AS "Project3"
> ) AS "Project4"
> ORDER BY "Project4"."ProductName" ASC
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> Message: 5
> Date: Thu, 15 Apr 2010 09:39:02 +0200
> From: Jiri Cincura <[email protected]>
> Subject: Re: [Firebird-net-provider] Help Using Linqpad
> To: "For users and developers of the Firebird .NET providers"
> <[email protected]>
> Message-ID:
> <[email protected]>
> Content-Type: text/plain; charset=ISO-8859-1
>
> How's your CSDL for the UnitPrice field looking?
>
> --
> Jiri {x2} Cincura (CTO x2develop.com)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
>
> ------------------------------
>
> Message: 6
> Date: Thu, 15 Apr 2010 13:30:13 +0200
> From: Marcin Kacprzak <[email protected]>
> Subject: [Firebird-net-provider] UTF-8 connection problem
> To: [email protected]
> Message-ID: <[email protected]>
> Content-Type: text/plain; charset="utf-8"
>
> Hello.
>
> I would like to connect:
> * using .NET provider for FireBird
> * to local database (file)
> * using UTF-8 charset for communication with database
> * my database file path contains polish diacritical signs
> * path charset is Windows1250
>
> The problem is when I try to connect with specified UTF8 enabled
> connection string,
> FireBird cannot recognize the path, because FB probably wants to read it
> as UTF-8 path.
>
> When path does not contain polish signs, FireBird connects properly.
>
> Below I paste my code:
>
>
> *sFilePath* is some path with polish diacritical signs.
>
> [code]
>
> sConnectionString = "ServerType = 1; User = SYSDBA; Password =
> masterkey; Dialect=3; Database = '" + sFilePath + "'; CHARSET = UTF8";
>
> ConnectionStringBuilder fbConnectionStringBuilder = new
> FbConnectionStringBuilder(sConnectionString);
>
> fbConnection = new FbConnection(fbConnectionStringBuilder.ToString());
> try
> {
> fbConnection.Open();
> }
> [/code]
>
> Here goes exception.
>
> How can I connect using UTF-8 connection, but force FB to read properly
> the database path?
>
> Thanx for any help
> Marcin
> -------------- next part --------------
> An HTML attachment was scrubbed...
>
> ------------------------------
>
> ------------------------------------------------------------------------------
> Download Intel® Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
> ------------------------------
>
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
>
> End of Firebird-net-provider Digest, Vol 48, Issue 5
> ****************************************************
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
