Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Wed, Sep 21, 2011 at 11:51 PM, Sam Carleton wrote: > Can someone shield some light on this? Maybe it's too early in the morning, but I don't know what the question is. :) -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
The question is: How can I hack the .Net provider such that I can change the .Net type based on the domain type of the column? My current thought is there is some way to associate the isc_info_sql_type and isc_info_sql_sub_type with the domain type. So, along these lines, what is the relationship between a domain type and the isc_info_sql_type and isc_info_sql_sub_type? Sam On Thu, Sep 22, 2011 at 3:59 AM, Jiri Cincura wrote: > On Wed, Sep 21, 2011 at 11:51 PM, Sam Carleton > wrote: >> Can someone shield some light on this? > > Maybe it's too early in the morning, but I don't know what the question is. :) > > -- > Jiri {x2} Cincura (x2develop.com founder) > http://blog.cincura.net/ | http://www.ID3renamer.com > > -- > All the data continuously generated in your IT infrastructure contains a > definitive record of customers, application performance, security > threats, fraudulent activity and more. Splunk takes this data and makes > sense of it. Business sense. IT sense. Common sense. > http://p.sf.net/sfu/splunk-d2dcopy1 > ___ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Thu, Sep 22, 2011 at 2:45 PM, Sam Carleton wrote: > My current thought is there is some way to associate the > isc_info_sql_type and isc_info_sql_sub_type with the domain type. So, > along these lines, what is the relationship between a domain type and > the isc_info_sql_type and isc_info_sql_sub_type? It's not related to domain itself, but the underlying type. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] ADO.NET Entity Framework 4.1 with Views
Hi I followed all the threads on views and added the following view to a 2.5 database using NETProvider-2.6.5 , VS2010, EF 4.1 -Update 1 Edmx Version="2.0". . I followed all steps below and the view shows up in the Model Bowser but not in the edmx model viewer. Is there something wrong with my code? Thanks, John 1) CREATE OR ALTER VIEW "VSupplier"( "SupplierID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region", "PostalCode", "Country", "Phone", "Fax", "HomePage") AS select "SupplierID", "CompanyName", "ContactName", "ContactTitle", "Address", "City", "Region", "PostalCode", "Country", "Phone", "Fax", "HomePage" from "Suppliers"; COMMENT ON COLUMN "VSupplier"."SupplierID" IS '#PK_GEN#'; 2) Add the following to ssdl http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSch emaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl";> a) b) -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Changing .Net type based on a Domain type
On Thu, Sep 22, 2011 at 10:54 AM, Jiri Cincura wrote: > On Thu, Sep 22, 2011 at 2:45 PM, Sam Carleton > wrote: >> My current thought is there is some way to associate the >> isc_info_sql_type and isc_info_sql_sub_type with the domain type. So, >> along these lines, what is the relationship between a domain type and >> the isc_info_sql_type and isc_info_sql_sub_type? > > It's not related to domain itself, but the underlying type. Ok, so is the domain type only really useful during the design of the DB. I say that from the prospective of: It aids a DB Admin in designing the DB, but from the programming side of things it has no effect. Sam -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2dcopy1 ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider