> I adjusted the subject as requested. John > > 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, > firebird-net-provider-requ...@lists.sourceforge.net wrote: > >> Send Firebird-net-provider mailing list submissions to >> firebird-net-provider@lists.sourceforge.net >> >> 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 >> firebird-net-provider-requ...@lists.sourceforge.net >> >> You can reach the person managing the list at >> firebird-net-provider-ow...@lists.sourceforge.net >> >> 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 <tgabo...@gmail.com> >> Subject: Re: [Firebird-net-provider] FirebirdSql.Data.Isql and >> newlines >> To: "For users and developers of the Firebird .NET providers" >> <firebird-net-provider@lists.sourceforge.net> >> Message-ID: >> <z2i30c102241004130843z84270e51yd64b1cd43114f...@mail.gmail.com> >> Content-Type: text/plain; charset=UTF-8 >> >> On Thu, Mar 25, 2010 at 9:59 PM, Jiri Cincura <disk...@cincura.net> 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 <disk...@cincura.net> >> Subject: Re: [Firebird-net-provider] FirebirdSql.Data.Isql and >> newlines >> To: "For users and developers of the Firebird .NET providers" >> <firebird-net-provider@lists.sourceforge.net> >> Message-ID: >> <x2qd2fa8bfb1004131147r5fdc1438p2a646f715004b...@mail.gmail.com> >> Content-Type: text/plain; charset=ISO-8859-1 >> >> 2010/4/13 G?bor T?r?k <tgabo...@gmail.com>: >>> 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" <intelru...@unrealsoft.net> >> Subject: [Firebird-net-provider] Named transactions >> To: "For users and developers of the Firebird .NET providers" >> <firebird-net-provider@lists.sourceforge.net> >> 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 <j...@gtz.com> >> Subject: [Firebird-net-provider] Help Using Linqpad >> To: firebird-net-provider@lists.sourceforge.net >> Message-ID: <2e78bf4c-4f2e-4790-9192-01218dc39...@gtz.com> >> 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 <m...@albahari.com>) 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 <disk...@cincura.net> >> Subject: Re: [Firebird-net-provider] Help Using Linqpad >> To: "For users and developers of the Firebird .NET providers" >> <firebird-net-provider@lists.sourceforge.net> >> Message-ID: >> <r2rd2fa8bfb1004150039nf049bcdfxb8e7f0feab852...@mail.gmail.com> >> 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 <kap...@tlen.pl> >> Subject: [Firebird-net-provider] UTF-8 connection problem >> To: firebird-net-provider@lists.sourceforge.net >> Message-ID: <4bc6f8c5.8080...@tlen.pl> >> 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 >> Firebird-net-provider@lists.sourceforge.net >> 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
