Re: [Firebird-net-provider] Integration with Visual Studio

2012-01-17 Thread Russell Rose
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

2012-01-17 Thread Muthu Annamalai
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

2012-01-17 Thread Jiri Cincura
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

2012-01-17 Thread Muthu Annamalai
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