Re: [Firebird-net-provider] Integration with Visual Studio
Here is the output from gacutil: Microsoft (R) .NET Global Assembly Cache Utility. Version 3.5.30729.1 Copyright (c) Microsoft Corporation. All rights reserved. The Global Assembly Cache contains the following assemblies: FirebirdSql.Data.FirebirdClient, Version=2.5.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c, processorArchitecture=MSIL Number of items = 1 Here is the machine.config new line: add name=FirebirdClient Data Provider invariant=FirebirdSql.Data.FirebirdClient description=.Net Framework Data Provider for Firebird type=FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.5.2.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c / I also tried Version=2.0.0.0 as well. I don't think I need to reboot after changing machine.config. I updated the following machine.config files: C:\Windows\Microsoft.NET\Framework\v2.0.50727\CONFIG C:\Windows\Microsoft.NET\Framework64\v2.0.50727\CONFIG -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Computedby Column Edmx Issue
The datatype of other columns that is showing properly is Numeric(15,4). The datatype of the computedby column is Numeric(15,8). I thought the decimal digits might be a problem, I created a numeric(15,4) domain and used that in the computedby column, but still no luck... Thanks! -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, January 17, 2012 12:54 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Computedby Column Edmx Issue On Mon, Jan 16, 2012 at 7:25 PM, Muthu Annamalai muthuannama...@sbcglobal.net wrote: numeric(15,4) What's the datatype of other columns? -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Computedby Column Edmx Issue
On Tue, Jan 17, 2012 at 4:00 PM, Muthu Annamalai muthuannama...@sbcglobal.net wrote: The datatype of other columns that is showing properly is Numeric(15,4). The datatype of the computedby column is Numeric(15,8). I thought the decimal digits might be a problem, I created a numeric(15,4) domain and used that in the computedby column, but still no luck... Thanks! Provide a DDL for that table. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Computedby Column Edmx Issue
Here is the DDL for the table. In this table the column QUANTITY and PRICE, which are Decimal4 (Numeric(15,4) domain that I created interpreted correctly). The last column (AMOUNT), which is a computedby column is interpreted as Int64 CREATE TABLE RECEIPTLINE ( ID INTEGER NOT NULL, RECEIPTIDINTEGER NOT NULL, ITEMSTYLEID INTEGER, QUANTITY DECIMAL4 NOT NULL /* DECIMAL4 = NUMERIC(15,4) DEFAULT 0 NOT NULL */, PRICEDECIMAL4 NOT NULL /* DECIMAL4 = NUMERIC(15,4) DEFAULT 0 NOT NULL */, TAXABLE SMALLINT NOT NULL, AMOUNT COMPUTED BY (QUANTITY * PRICE - (SELECT COALESCE(SUM(DISCOUNT),0) FROM RECEIPTDISCOUNT WHERE RECEIPTDISCOUNT.RECEIPTLINEID = ID)) ); -Original Message- From: Jiri Cincura [mailto:disk...@cincura.net] Sent: Tuesday, January 17, 2012 9:50 AM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] Computedby Column Edmx Issue On Tue, Jan 17, 2012 at 4:00 PM, Muthu Annamalai muthuannama...@sbcglobal.net wrote: The datatype of other columns that is showing properly is Numeric(15,4). The datatype of the computedby column is Numeric(15,8). I thought the decimal digits might be a problem, I created a numeric(15,4) domain and used that in the computedby column, but still no luck... Thanks! Provide a DDL for that table. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider