Re: [Firebird-net-provider] Entity Model
Hi again, did you try to use those exports in a VS project ? because, even if edmgen file created files (in spite of keys/not null problems), I still have a ProviderManifestToken to 2.1.1.17910 while Firebird seems required during runtime, and I still have the ShemaInformation problem. Thierry Jiri Cincura a écrit : Is it possible that the weekly build is not compiled with a full EF configuration ? edmgen /mode:FullGeneration /provide r:FirebirdSql.Data.FirebirdClient /connectionstring:data source=localhost;initi al catalog=rrr.fdb;user id=sysdba;password=masterkey /project:Kuk Microsoft (R) EdmGen version 3.5.0.0 Copyright (C) 2008 Microsoft Corporation. All rights reserved. Loading database information... warning 6002: The table/view 'Firebird.ABC' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/v iew. warning 6013: The table/view 'Firebird.FOOBAR' does not have a primary key defin ed and no valid primary key could be inferred. This table/view has been excluded . To use the entity you will need to review your schema, add the correct keys an d uncomment it. Writing ssdl file... Creating conceptual layer from storage layer... Writing msl file... Writing csdl file... Writing object layer file... Writing views file... Generation Complete -- 0 errors, 2 warnings - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Hi, as I thought, other dll were from personal builds of provider. To be sure, I deleted them, sources etc of provider I just left the weekly build one (the only remaining are in provider setup dir, and in c:\windows\assembly\gac_msil\..., which are the same) I force a reinstallation via gacutil (/f /i) and still have the problems: when I create model via VS wizard, I've got WI-V2.1.1.17910 Firebird 2.1 in ProviderManifestToken but runtime still waits for Firebird If I correct the error manually, I've got the other problem (that I'm not able to solve for now, but I'm on it): Le schéma spécifié n'est pas valide. Erreurs : \r\nFirebirdSql.Entity.StoreSchemaMapping.msl(3,4) : erreur 2002: L'EntityContainer « SchemaInformation » du modèle conceptuel spécifié dans le cadre de ce code MSL n'existe pas dans MetadataWorkspace. in English (more or less): Schema specified is not valid: The EntityContainer « SchemaInformation » from conceptual model specified in msl doesn't exist in MetadataWorkspace Is the Provider supposed to work when using VS wizard, or was it only tested with edmgen ? Thierry Teträm Corp a écrit : Jiri Cincura a écrit : On Fri, Nov 14, 2008 at 15:14, Tetram Corp [EMAIL PROTECTED] wrote: great, but during runtime, when i need to access results of a linq query, an exception is raised saying it was attempting Firebird as ProviderManifestToken and not 2.1.1.17910 You're not using same assembly for VS and runtime. It surprises me because I'm pretty sure to have only one. But thanks, I will check that on Monday. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Jiri Cincura a écrit : On Mon, Nov 17, 2008 at 11:37, Tetram Corp [EMAIL PROTECTED] wrote: Is the Provider supposed to work when using VS wizard, or was it only tested with edmgen ? Both VS and EdmGen. In fact both tools are using same API. ok do you think it's still an installation problem or should it be a problem in the Provider ? because I've no more idea to solve it. - only one dll (I restart the computer to be sure, there's no in memory cache in action) - no specific use of the wizard may be the model itself: I'v got a double association between to entities. Could it be the reason of the Schema problem ? Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
If it helps, here is the generated .edmx (as is: no modifications from me) Thierry ?xml version=1.0 encoding=utf-8? edmx:Edmx Version=1.0 xmlns:edmx=http://schemas.microsoft.com/ado/2007/06/edmx; !-- EF Runtime content -- edmx:Runtime !-- SSDL content -- edmx:StorageModels Schema Namespace=Model.Store Alias=Self Provider=FirebirdSql.Data.FirebirdClient ProviderManifestToken=WI-V2.1.1.17910 Firebird 2.1 xmlns:store=http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator; xmlns=http://schemas.microsoft.com/ado/2006/04/edm/ssdl; EntityContainer Name=ModelStoreContainer EntitySet Name=LABO EntityType=Model.Store.LABO store:Type=Tables Schema=Firebird / EntitySet Name=TRANSFERT_TUBES EntityType=Model.Store.TRANSFERT_TUBES store:Type=Tables Schema=Firebird / /EntityContainer EntityType Name=LABO Key PropertyRef Name=NUM_LAB / PropertyRef Name=NOM_LABO / PropertyRef Name=NOM_LIVR / PropertyRef Name=ADR_LIVRAISON / PropertyRef Name=ADR_FACTURATION / PropertyRef Name=CODE_POSTAL_LIVRAISON / PropertyRef Name=CODE_POSTAL_FACTURATION / PropertyRef Name=VILLE_LIVRAISON / PropertyRef Name=VILLE_FACTURATION / PropertyRef Name=ANCIEN_LABO / PropertyRef Name=ADR_LIVR2 / PropertyRef Name=ADR_FACTU2 / PropertyRef Name=CODE_LABO / PropertyRef Name=TEL_LABO / PropertyRef Name=FAX_LABO / PropertyRef Name=CODESFRL / PropertyRef Name=NUM_PLATEAU / PropertyRef Name=NUM_COLLONE_ANALYSE / PropertyRef Name=NOM_COLLONE_ANALYSE / PropertyRef Name=MAGH2 / /Key Property Name=NUM_LAB Type=int Nullable=false / Property Name=NOM_LABO Type=varchar Nullable=false MaxLength=50 / Property Name=NOM_LIVR Type=varchar MaxLength=50 / Property Name=ADR_LIVRAISON Type=varchar MaxLength=50 / Property Name=ADR_FACTURATION Type=varchar MaxLength=50 / Property Name=CODE_POSTAL_LIVRAISON Type=varchar MaxLength=5 / Property Name=CODE_POSTAL_FACTURATION Type=varchar MaxLength=5 / Property Name=VILLE_LIVRAISON Type=varchar MaxLength=50 / Property Name=VILLE_FACTURATION Type=varchar MaxLength=50 / Property Name=ANCIEN_LABO Type=varchar MaxLength=1 / Property Name=ADR_LIVR2 Type=varchar MaxLength=50 / Property Name=ADR_FACTU2 Type=varchar MaxLength=50 / Property Name=CODE_LABO Type=varchar MaxLength=6 / Property Name=TEL_LABO Type=varchar MaxLength=15 / Property Name=FAX_LABO Type=varchar MaxLength=15 / Property Name=CODESFRL Type=varchar MaxLength=35 / Property Name=NUM_PLATEAU Type=int / Property Name=NUM_COLLONE_ANALYSE Type=int / Property Name=NOM_COLLONE_ANALYSE Type=varchar MaxLength=20 / Property Name=MAGH2 Type=varchar Nullable=false MaxLength=1 / /EntityType EntityType Name=TRANSFERT_TUBES Key PropertyRef Name=NUM_TRANSFERT / PropertyRef Name=NUM_LOT / PropertyRef Name=NUM_LAB_ORIG / PropertyRef Name=REF_OPE_ORIG / PropertyRef Name=SERVEUR_OPE_ORIG / PropertyRef Name=NUM_LAB_DEST / PropertyRef Name=REF_OPE_DEST / PropertyRef Name=SERVEUR_OPE_DEST / PropertyRef Name=DATE_ENVOI / PropertyRef Name=DATE_ARRIVE / PropertyRef Name=DATE_DOSSIER / PropertyRef Name=DOSSIER / PropertyRef Name=CODEBARRE / /Key Property Name=NUM_TRANSFERT Type=int Nullable=false / Property Name=NUM_LOT Type=int Nullable=false / Property Name=NUM_LAB_ORIG Type=int / Property Name=REF_OPE_ORIG Type=int / Property Name=SERVEUR_OPE_ORIG Type=int / Property Name=NUM_LAB_DEST Type=int / Property Name=REF_OPE_DEST Type=int / Property Name=SERVEUR_OPE_DEST Type=int / Property Name=DATE_ENVOI Type=timestamp / Property Name=DATE_ARRIVE Type=timestamp / Property Name=DATE_DOSSIER Type=timestamp / Property Name=DOSSIER Type=varchar MaxLength=20 / Property Name=CODEBARRE Type=varchar MaxLength=20 / /EntityType /Schema /edmx:StorageModels !-- CSDL content -- edmx:ConceptualModels Schema Namespace=Model Alias=Self xmlns=http://schemas.microsoft.com/ado/2006/04/edm; EntityContainer Name=Entities4 EntitySet Name=LABO EntityType=Model.LABO / EntitySet Name=TRANSFERT_TUBES EntityType=Model.TRANSFERT_TUBES / /EntityContainer EntityType Name=LABO Key PropertyRef Name=NUM_LAB / PropertyRef Name=NOM_LABO / PropertyRef
Re: [Firebird-net-provider] Entity Model
and here is the result with edmgen: C:\WINDOWS\Microsoft.NET\Framework\v3.5edmgen /project:gesstock /language:CShar p /mode:FullGeneration /provider:FirebirdSql.Data.FirebirdClient /connectionstri ng:data source=127.0.0.1;initial catalog=c:\stockpro.fdb;user id=sysdba;passwor d=masterkey\ Microsoft (R) EdmGen version 3.5.0.0 Copyright (C) 2008 Microsoft Corporation. Tous droits réservés. erreur 7001: Le fournisseur n'a pas retourné de chaîne ProviderManifestToken. Le format de la chaîne d'initialisation n'est pas conforme à la spécific ation qui débute à l'index 69. Génération terminée -- 1 erreurs, 0 avertissements The provider didn't return a ProviderManifestToken string Is it possible that the weekly build is not compiled with a full EF configuration ? Thierry Tetram Corp a écrit : If it helps, here is the generated .edmx (as is: no modifications from me) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
ok, what I did: - clean windows install (xp sp3) - clean vs 2008 install (including sp and framework 3.5 sp1) - install of provider using current FirebirdClient-2.5.0-Alpha2 from ibphoenix (fresh download; I got this one because of FW 3.5), including modifying machine.config - install of DDEX including registry modifications (couple vs+fb provider works well there) - copy of weekly build of provider in place of provider - gacutil of weekly build running the edmgen command line I show you in previous mail, gives the error already indicated so, I guess you've got something on your system (registry, or something else) I'm missing. The question is what. Thierry Jiri Cincura a écrit : Is it possible that the weekly build is not compiled with a full EF configuration ? edmgen /mode:FullGeneration /provide r:FirebirdSql.Data.FirebirdClient /connectionstring:data source=localhost;initi al catalog=rrr.fdb;user id=sysdba;password=masterkey /project:Kuk Microsoft (R) EdmGen version 3.5.0.0 Copyright (C) 2008 Microsoft Corporation. All rights reserved. Loading database information... warning 6002: The table/view 'Firebird.ABC' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/v iew. warning 6013: The table/view 'Firebird.FOOBAR' does not have a primary key defin ed and no valid primary key could be inferred. This table/view has been excluded . To use the entity you will need to review your schema, add the correct keys an d uncomment it. Writing ssdl file... Creating conceptual layer from storage layer... Writing msl file... Writing csdl file... Writing object layer file... Writing views file... Generation Complete -- 0 errors, 2 warnings - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
ok, the problem was in my commandline: \ after masterkey shouldn't be there Thierry Tetram Corp a écrit : ok, what I did: - clean windows install (xp sp3) - clean vs 2008 install (including sp and framework 3.5 sp1) - install of provider using current FirebirdClient-2.5.0-Alpha2 from ibphoenix (fresh download; I got this one because of FW 3.5), including modifying machine.config - install of DDEX including registry modifications (couple vs+fb provider works well there) - copy of weekly build of provider in place of provider - gacutil of weekly build running the edmgen command line I show you in previous mail, gives the error already indicated so, I guess you've got something on your system (registry, or something else) I'm missing. The question is what. Thierry Jiri Cincura a écrit : Is it possible that the weekly build is not compiled with a full EF configuration ? edmgen /mode:FullGeneration /provide r:FirebirdSql.Data.FirebirdClient /connectionstring:data source=localhost;initi al catalog=rrr.fdb;user id=sysdba;password=masterkey /project:Kuk Microsoft (R) EdmGen version 3.5.0.0 Copyright (C) 2008 Microsoft Corporation. All rights reserved. Loading database information... warning 6002: The table/view 'Firebird.ABC' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/v iew. warning 6013: The table/view 'Firebird.FOOBAR' does not have a primary key defin ed and no valid primary key could be inferred. This table/view has been excluded . To use the entity you will need to review your schema, add the correct keys an d uncomment it. Writing ssdl file... Creating conceptual layer from storage layer... Writing msl file... Writing csdl file... Writing object layer file... Writing views file... Generation Complete -- 0 errors, 2 warnings - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
hi as promised, a first feedback, when i create a new model using wizard, VS add this node: Schema Namespace=Model.Store Alias=Self Provider=FirebirdSql.Data.FirebirdClient ProviderManifestToken=2.1.1.17910 ... great, but during runtime, when i need to access results of a linq query, an exception is raised saying it was attempting Firebird as ProviderManifestToken and not 2.1.1.17910 and if I change manually my edmx file to put Firebird instead of 2.1.etc, no exception is raised, and VS still works correctly with this model do you know where did come from the value of ProviderManifestToken and why it is not Firebird as runtime seems to wait for ? is it something I missed during provider installation, or is it a bug (or a misunderstanding) ? Thierry Tetram Corp a écrit : Hi, I'm trying to create an Entity Model (to use Linq) with VS2008. My problem is that Firebird provider is not available in the Entity Model wizard while it is available when creating a connection string. Did I missed something ? (a reg file or something else) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Hi again, another feedback, is it normal that when I add a new table to my model, all properties are marked Entity key = true shouldn't be only primary keys ? or at least none because it's easier to set one or two property as entity key than remove all other properties from key (all table fields minus real key) Thierry Tetram Corp a écrit : Hi, I'm trying to create an Entity Model (to use Linq) with VS2008. My problem is that Firebird provider is not available in the Entity Model wizard while it is available when creating a connection string. Did I missed something ? (a reg file or something else) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
more informations, 2.1.1.17910 value is added with my debug build the weekly build add WI-V2.1.1.17910 Firebird 2.1 but in both cases, Firebird is waited for runtime I guess it's because of this line Schema Namespace=FirebirdClient_EF Provider=FirebirdSql.Data.FirebirdClient ProviderManifestToken=Firebird Alias=Self ... in \NETProvider\source\FirebirdSql\Data\Entity\StoreSchemaDefinition.ssdl Thierry Tetram Corp a écrit : hi as promised, a first feedback, when i create a new model using wizard, VS add this node: Schema Namespace=Model.Store Alias=Self Provider=FirebirdSql.Data.FirebirdClient ProviderManifestToken=2.1.1.17910 ... great, but during runtime, when i need to access results of a linq query, an exception is raised saying it was attempting Firebird as ProviderManifestToken and not 2.1.1.17910 and if I change manually my edmx file to put Firebird instead of 2.1.etc, no exception is raised, and VS still works correctly with this model do you know where did come from the value of ProviderManifestToken and why it is not Firebird as runtime seems to wait for ? is it something I missed during provider installation, or is it a bug (or a misunderstanding) ? Thierry Tetram Corp a écrit : Hi, I'm trying to create an Entity Model (to use Linq) with VS2008. My problem is that Firebird provider is not available in the Entity Model wizard while it is available when creating a connection string. Did I missed something ? (a reg file or something else) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Entity Model
Hi, I'm trying to create an Entity Model (to use Linq) with VS2008. My problem is that Firebird provider is not available in the Entity Model wizard while it is available when creating a connection string. Did I missed something ? (a reg file or something else) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Hi, I've got the same error with that build. Do you think my metadata could be helpful to solve the problem or is it a known one ? (I missed to say the error occurs when VS try to retrieve database informations) I also tried with the same database but without any stored proc or triggers (I read something about a problem with stored proc) but doesn't change anything. Sorry if I'm spaming a bit the list, but as you can see, I'm very interested by Entities. My limited test case is about only 3 or 4 tables (a little more entities), but my final app will use more than 100 tables (and much more entities) so if I can avoid having to create manually my classes/requests, I think I could not be happier ;-) Thierry Tetram Corp a écrit : Well, I found them at http://netprovider.cincura.net/, is it still correct ? (the mail was on 2006 or 2007) Thierry Tetram Corp a écrit : could you remind me where i can find weekly builds ? is it 2.5 Alpha 2 on sourceforge ? Jiri Cincura a écrit : On Thu, Nov 13, 2008 at 12:00, Tetram Corp [EMAIL PROTECTED] wrote: FirebirdSql.Data.FirebirdClient And put this one into GAC. You can download build also from weekly builds. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Hi, I didn't know replacing the already added into GAC dll by the new one is not enough :-) thanks a lot for now, edmgen gives me a new error but I think I should test with the weekly build. The new error is: erreur 6003: Une erreur s'est produite lors de l'exécution de la définition de la commande. Pour plus de détails, consultez l'exception interne. Dynamic SQL Error SQL error code = -104 Token unknown - line 16, column 8 SELECT Une exception de type 'FirebirdSql.Data.Common.IscException' a été levée. VS doesn't speak really more : it just says that's a System.Data.EntityCommandExecutionException caused by a FirebirdSQL.Data.FirebirdClient.FbException could you remind me where i can find weekly builds ? is it 2.5 Alpha 2 on sourceforge ? and last, do you know about any roadmap for this feature ? Thierry Jiri Cincura a écrit : On Thu, Nov 13, 2008 at 12:00, Tetram Corp [EMAIL PROTECTED] wrote: FirebirdSql.Data.FirebirdClient And put this one into GAC. You can download build also from weekly builds. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Well, I found them at http://netprovider.cincura.net/, is it still correct ? (the mail was on 2006 or 2007) Thierry Tetram Corp a écrit : could you remind me where i can find weekly builds ? is it 2.5 Alpha 2 on sourceforge ? Jiri Cincura a écrit : On Thu, Nov 13, 2008 at 12:00, Tetram Corp [EMAIL PROTECTED] wrote: FirebirdSql.Data.FirebirdClient And put this one into GAC. You can download build also from weekly builds. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
I also tried to use edmgen.exe, but I've got this error: erreur 7001: Une valeur Null a été retournée après l'appel de la méthode « GetService » sur une instance de fournisseur de magasins de type « FirebirdSql.Data.FirebirdClient.FirebirdClientFactory ». Le fournisseur de magasins risque de ne pas fonctionner correctement. In English, it should be something like: error 7001: A Null value was returned by the method GetService with an instance of « FirebirdSql.Data.FirebirdClient.FirebirdClientFactory ». Does this mean I should use a svn build ? Thierry Tetram Corp a écrit : Hi, I'm trying to create an Entity Model (to use Linq) with VS2008. My problem is that Firebird provider is not available in the Entity Model wizard while it is available when creating a connection string. Did I missed something ? (a reg file or something else) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Entity Model
Jiri Cincura a écrit : On Thu, Nov 13, 2008 at 14:10, Tetram Corp [EMAIL PROTECTED] wrote: Do you think my metadata could be helpful to solve the problem or is it a known one ? Maybe ... Check the output window of VS to see the query that's actually executed. The debug builds are printing the command there. You can find what's wrong with query. even through the Entity Model wizard ? because I checked: - weekly bluid through wizard and through command line - svn sln (configuration DEBUG) through wizard and through command line and none show me the query is there a special way to get it ? (I guess when running the project when entities already created/mapped but unfortunately I'm not able to produce an .edmx file manually to bypass the wizard :-( ) otherwise, I just added some System.IO.File.AppendAllText and got the query in my file and now, I understand I missed the BIGGEST point.. My dev server is under FB 1.5 :-( very sorry It works well with FB 2.1 I will process more tests and will give some feedback Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] LINQ support
Thanks But it seems the official way is becoming LINQ to Entity (see Carlos link) so i think i will change my pov Thierry Alexey V. Tyul'kin a écrit : if not, are there plans for a real LINQ to FB.SQL (if doable of course ) ? http://code.google.com/p/dblinq2007/ supports Fb - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] LINQ support
thanks a lot your link is very helpful Thierry Carlos a écrit : Hello: are there some news from LINQ support since last spring, or is still through Entity Framework and ADO.NET ? if not, are there plans for a real LINQ to FB.SQL (if doable of course :-) ) ? The right way for this is to use the Linq to Entities, IMHO, and it's more clear to me after have see what is going to happen with linq to sql server, http://blogs.msdn.com/adonet/archive/2008/10/31/clarifying-the-message-on-l2s-futures.aspx - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Provider with ASP.NET
Hi, I'm using the provider to build a website with ASP.NET All works fine except when I've got an FB error, the message is not resolved with firebird.msg. I tried to put the file in C:\Windows\System32, the provider directory, my website directory, or IIS bin directory no change Where does the provider look for firebird.msg ? or, a little out of topic, is there someone who kowns where to put the file when using FB for an ASP.NET website? Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 DDEX probem
Jiri Cincura a écrit : On Thu, Sep 4, 2008 at 10:44 AM, Christian Nylund [EMAIL PROTECTED] wrote: Ok, that's the background. Here comes the problem: When I add a new DataSource I can find the Firebird provider in the list of providers. I can add a new Connection and even testing the connection works fine. However, when I click OK I get an error message saying Unable to add data connection. Cannot load type with name 'FirebirdSql.VisualStudio.DataTools.FbDataObjectEnumerator'. Hello, this is issue should be fixed in 2.0.4. Thanks a lot, it works well :-) Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Provider v2.0.4 for Visual Studio
Jiri Cincura a écrit : Hello, the DDEX Provider v2.0.4 for Visual Studio has been released. Download it from http://www.firebirdsql.org/index.php?op=filesid=netprovider . Hi, a question about reg files: the readme says to modify the reg file we want to merge, like this: configuration configSections ... section name=firebirdsql.data.firebirdclient type=System.Data.Common.DbProviderConfigurationHandler, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 / ... configSections ... system.data DbProviderFactories ... 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=%Version%, Culture=%Culture%, PublicKeyToken=%PublicKeyToken% / ... /DbProviderFactories /system.data /configuration and to change %values% with correct values. Is it correct that in section node, Version, Culture and PublicKeyToken still have their values ? Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] DDEX setup
Hi, I just try the MySQL DataProvider msi and it install provider and DDEX without machine.config to update, .reg to merge absolutly nothing and it works with VS 2005/2008 Couldn't the same be done to Firebird provider/ddex? mysql gift: the msi source is available freely :) http://dev.mysql.com/downloads/ Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 DDEX probem
Hi, I'm not sure to understand what you did: You installed the version 2.0.1 of what ? Data provider or DDEX ? Thierry Christian Nylund a écrit : I found an older version, 2.0.1 to be exact, and that worked like a charm. So there's nothing wrong with my installation, all I did was exchange the FirebirdSql.VisualStudio.DataTools.dll for an earlier version and everything worked just fine. Thanks for trying to help me out guys. C. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 DDEX probem
Is it possible for you to send it to tetram76 at gmail dot com ? pleaaase :) Thierry Christian Nylund a écrit : In my trashcan. Sometimes it pays to forget to empty it. The 2.0.3 install was an upgrade so I used my old file. C. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teträm Corp Sent: den 5 september 2008 16:24 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] VS2008 DDEX probem clearer indeed :) I'm very interested, where did you find it ? Thierry Christian Nylund a écrit : I didn't change the install at all. All I did was switch to an earlier version of the FirebirdSql.VisualStudio.DataTools.dll. As in actually replacing the file in my installation folder (while of course saving a copy of the old one) with the older one. I still have version 2.5.0.0 of the provider and I have performed all the steps of the 2.0.3 DDEX installation, plus changing the .dll mentioned above. Hope that was clearer ;) C. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tetram Corp Sent: den 5 september 2008 15:52 To: For users and developers of the Firebird .NET providers Subject: Re: [Firebird-net-provider] VS2008 DDEX probem Hi, I'm not sure to understand what you did: You installed the version 2.0.1 of what ? Data provider or DDEX ? Thierry Christian Nylund a écrit : I found an older version, 2.0.1 to be exact, and that worked like a charm. So there's nothing wrong with my installation, all I did was exchange the FirebirdSql.VisualStudio.DataTools.dll for an earlier version and everything worked just fine. Thanks for trying to help me out guys. C. - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Roadmap
Hi, is there a place I can find the roadmap of the .net provider. I'm starting a new dev and I need to know when 2.5 final will be released to choose if I can work with Alpha version or if it's better to wait. Thierry - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] VS2008 DDEX probem
I've got the same problem Even after I installed the VS SDK, I've got the same error. More, FirebirdDDEXProviderPackageLess32 seems no more included in DDEX package (I download it today) Thierry Christian Nylund a écrit : As far as I can tell they are identical. Anyhow, I still get the same error I’m afraid. Thanks anyway. *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Mercea Paul *Sent:* den 4 september 2008 11:09 *To:* 'For users and developers of the Firebird .NET providers' *Subject:* Re: [Firebird-net-provider] VS2008 DDEX probem Try with FirebirdDDEXProviderPackageLess32 if you don’t have VS SDK installed! Regards, Paul *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Christian Nylund *Sent:* Thursday, September 04, 2008 11:44 AM *To:* Firebird-net-provider@lists.sourceforge.net *Subject:* [Firebird-net-provider] VS2008 DDEX probem /Sorry if this is a repost – everything crashed when I sent it so I’m resending just in case./ Hi, I use VS2008 on a WinXPPro machine. I have installed the FirebirdClient-2.5.0-Alpha2. I have followed the instructions in FirebirdDDEXProvider-2.0.3, including installing the FirebirdSql.VisualStudio.DataTools.dll with gacutil.exe. I have changed the machine.config (and double checked it like a million times). I have changed the path in FirebirdDDEXProvider32.reg (from the FirebirdDDEXProvider-2.0.3) and committed it to the registry. Ok, that’s the background. Here comes the problem: When I add a new DataSource I can find the Firebird provider in the list of providers. I can add a new Connection and even testing the connection works fine. However, when I click OK I get an error message saying “/Unable to add data connection. Cannot load type with name ‘FirebirdSql.VisualStudio.DataTools.FbDataObjectEnumerator’.”/ Obviously VS cannot find FirebirdSql.VisualStudio.DataTools.dll, but how do I remedy that? Adding it as a project reference doesn’t work, not that that really was a surprise. Or can it be something else? Both FirebirdClient and the DDEX files are installed to “/C:\Program Files\FirebirdClient 2.0/”. Please help //Christian - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] Roadmap
Thanks, no I don't really need something special. It's just I'm beginning a new dev and I think it's better to use the latest stable version for our final release. So if 2.5 become Final during my dev, it's not a problem to dev with an alpha release. Thierry Mercea Paul a écrit : Hi I'm using 2.5 all ready in several projects. As I know, 2.5 will provide .net entity provider ... Do you need something else? Regards, Paul -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tetram Corp Sent: Thursday, September 04, 2008 3:16 PM To: Firebird-net-provider@lists.sourceforge.net Subject: [Firebird-net-provider] Roadmap Hi, is there a place I can find the roadmap of the .net provider. I'm starting a new dev and I need to know when 2.5 final will be released to choose if I can work with Alpha version or if it's better to wait. Thierry --- -- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider - This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100url=/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
[Firebird-net-provider] Accessing dbfile with ODS 11
i'm trying to connect to a db with an ods 11 (FB2.0) but I'v got some errors i don't understand: my connection string is: user=SYSDBA;password=masterkey;database=g:\programmation\media.kit\bdthèque\bin\bd.gdb;datasource=127.0.0.1;port=3050;dialect=3;charset=NONE;connection lifetime=15;pooling=true;minpoolsize=0;maxpoolsize=50;packet size=8192;servertype=Default in this case, I got an exception saying ODS is not supported if I change servertype to Context, the exception says unable to load dll 'clrexternalengine': not found (not the exact message: translated from french) and if I change servertype to Embedded, i can connect to my database so 2 questions: - is ODS11 supported or not by .Net provider? I tought that FB2 is supported - which file i missed that .Net provider is not able to load clrexternalengine? I use the provider v2.0.1 - Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.phpp=sourceforgeCID=DEVDEV ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
