CodeSmith Community
Your Code. Your Way. Faster!
Forums » File Share » Addins » Firebird schema provider using FirebirdSql.Data.Firebird

Firebird schema provider using FirebirdSql.Data.Firebird

Previous | Next
Latest post 08-25-2007 3:25 AM by bacos. 9 replies.

  • 03-02-2004 9:48 PM

    • Soernt
    • Top 500 Contributor
    • Joined on 02-23-2004
    • Posts 11
    • Points 255

    Firebird schema provider using FirebirdSql.Data.Firebird

    FirebirdSchemaProvider.zip
    Reply |Contact
    Hello everyone,
    this is my contribution to CodeSmith. Binaries and sources are included.
     
    I used the 1.5 release version of Firebird:

    You need the current Firebird Provider:
     
    Let me know If you have any problems with the provider.
     
    have fun
     
    Soernt
     
    This is allways the latest version.

    Post Edited (Soernt) : 5/16/2004 12:31:07 PM GMT
    • Post Points: 90

  • 03-11-2004 7:41 AM In reply to

    • brad
    • Not Ranked
    • Joined on 03-11-2004
    • Posts 3
    • Points 15

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Dear sir, it's really nice of you to share this online. Have you done any stored procedure generating templates for firebird database based on this Schema Provider? If you have and would like to share it, I'd say so many thanks to you!
    • Post Points: 5

  • 03-11-2004 5:41 PM In reply to

    • Soernt
    • Top 500 Contributor
    • Joined on 02-23-2004
    • Posts 11
    • Points 255

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Hello Brad,
     
    I currently working on a template but it isn't finished yet. It is also very specific to my needs.
    But perhaps it will be a starting point. As soon as I have finished the template I will post it.
    I try to get it done over the weekend.
     
    Best regards
     
    Soernt
    • Post Points: 5

  • 03-12-2004 5:45 AM In reply to

    • brad
    • Not Ranked
    • Joined on 03-11-2004
    • Posts 3
    • Points 15

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Oh, it sounds fantastic, hope to see your post soon:)
    • Post Points: 5

  • 03-13-2004 8:09 PM In reply to

    • Soernt
    • Top 500 Contributor
    • Joined on 02-23-2004
    • Posts 11
    • Points 255

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Hello everyone,
     
    this is an updated version.
    There is now a extended Property "SqlDDL" at the field level.
    It contains the SQL fieldtyp definition. It handy while creating stored procedures etc.
     
    I also posted in the "Template share" a template for creating
    Insert, Update and Delete stored procedures.
     
    Let me know if you have any problems with the provider.
     
    Have fun
     
    Soernt
    (Removed attachment. See my first post for the latest version.)

    Post Edited (Soernt) : 5/16/2004 12:33:47 PM GMT
    • Post Points: 5

  • 04-04-2004 5:04 PM In reply to

    • Soernt
    • Top 500 Contributor
    • Joined on 02-23-2004
    • Posts 11
    • Points 255

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Hello everyone,
     
    this is an updated version.
    The connection and transaction handling has changed.
     
    Let me know if you have any problems with the provider.
     
    regards
     
    Soernt
     
    (Removed attachment. See my first post for the latest version.)

    Post Edited (Soernt) : 5/16/2004 12:33:56 PM GMT
    • Post Points: 5

  • 05-16-2004 12:39 PM In reply to

    • Soernt
    • Top 500 Contributor
    • Joined on 02-23-2004
    • Posts 11
    • Points 255

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Hello everyone,
     
    this is an updated version.
    Many thanks goes out to Daniele Teti for fixing a field length bug (char/varchar).
    In addition there was a bug at resolving the primary key fields of a foreign table.
     
    See my first post for the latest version.
    Let me know if you have any problems with the provider.
     
    regards
     
    Soernt
    • Post Points: 5

  • 11-03-2004 8:43 PM In reply to

    RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact
    Has anyone managed to get the Schema Provider working with 2.6?

    Regards,
    M
    • Post Points: 35

  • 04-21-2007 10:39 PM In reply to

    • WeeBubba
    • Top 500 Contributor
    • Joined on 01-04-2007
    • Posts 10
    • Points 330

    Re: RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact

     first of all, thankyou very much for this great piece of code. it is proving invaluable to me. i am using this schema provider with Codesmith 4.0. it works great apart from one issue i found.
    i was wondering whether you guys could think of a quick fix.

    i notice that if a column is enforced NOT NULL manually then your code picks this up. however if a column is enforced NOT NULL by a domain then it is not picking this up.

    e.g --->

    CREATE DOMAIN D_GUID AS
    CHAR(38) CHARACTER SET OCTETS
    NOT NULL
    COLLATE OCTETS


    i was wondering what could be done about this? thanks.
     
    • Post Points: 35

  • 08-25-2007 3:25 AM In reply to

    • bacos
    • Not Ranked
    • Joined on 08-23-2007
    • Posts 1
    • Points 5

    Re: RE: Firebird schema provider using FirebirdSql.Data.Firebird

    Reply |Contact

    Hi all !

    I'm evaluating CodeSmith 4 and I'm trying to use it with firebird database.  But, I just can't make it work in Schema Explorer window.  I've put the FirebirdSchemaProvider.dll into SchemaProviders directory, I've tried to change its name to SchemaExplorer.FirebirdSchemaProvider.dll and did't work.

    Softwares that I'm using:

    - Firebird 1.5

    - Firebird .net data provider 1.7.1 and 2.x

    - .Net framework 1.1 and 2.0 

    Any help will be wellcome.

    Thank you !

    Bacos
     
    • Post Points: 5
Page 1 of 1 (10 items) | RSS
Copyright © 2008 CodeSmith Tools, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems