Calling .NET libs from Delphi?

-
Calling .NET libs from Delphi?
Basically, I'd like to call sql generators from .NET System.Data.SqlClient, like it is done here:
http://scriptdb.codeplex.com/SourceControl/latest#ScriptDB/DatabaseScripter.cs

How much bending over backwards is required to to do this?

#sql

Comments

  1. Jørn Einar AngeltveitSeptember 24, 2013 at 12:32 PM

    RemObjects Hydra?

    ReplyDelete
  2. Lars FosdalSeptember 24, 2013 at 12:39 PM

    Too much luggage.  Need something less generic.

    ReplyDelete
  3. Lachlan GemmellSeptember 24, 2013 at 12:39 PM

    http://ww2.atozed.com/CrossTalk/index.html

    ReplyDelete
  4. Lars FosdalSeptember 24, 2013 at 12:43 PM

    Who's the author, Lachlan Gemmell?
    CT looks interesting!

    ReplyDelete
  5. Lachlan GemmellSeptember 24, 2013 at 12:46 PM

    It's AtoZed Software of IntraWeb fame. I haven't used it personally.

    ReplyDelete
  6. Kenneth CochranSeptember 24, 2013 at 12:50 PM

    Just for completeness

    http://www.managed-vcl.com/

    Honestly the first thing I'd try is to just import the assembly in Delphi. Failing that I'd try exposing the functionality as a COM compatible wrapper and import that.

    Only after failing at both of those would I spend money on one of the third party libraries.

    ReplyDelete
  7. Lachlan GemmellSeptember 24, 2013 at 12:50 PM

    It's also possible to do straight from Delphi but with a fair bit more mucking around.
    http://www.blong.com/Articles/DotNetInteropD8/Interop1/Win32AndDotNetInterop.htm

    ReplyDelete
  8. Linas NaginionisSeptember 24, 2013 at 12:51 PM

    Haven't tried it but this can  help: http://adamjohnston.me/2013/04/14/delphi-dotnet-interop-with-jvcl/

    ReplyDelete
  9. Kenneth CochranSeptember 24, 2013 at 1:00 PM

    If you need to do this from the IDE, it's already a CLR host. There used to be some meager documentation on the interfaces they expose for assembly extension writers (more or less mirrors the interfaces exposed for native extensions) but I'm sure one of the many IL "reflector" tools out there would be more thorough.

    ReplyDelete
  10. Lars FosdalSeptember 24, 2013 at 1:18 PM

    Kenneth Cochran - Not from the IDE, although that could have it's uses too.

    ReplyDelete
  11. Dorin DuminicaSeptember 25, 2013 at 12:01 AM

    Lars Fosdal I've wrote something simple using RTTI, basically it creates the SQL dynamically and executes on connection, works noicely with pg and sqlite -- can't share code ): -- but this requires published properties and attributes on fields and "table" object, however, it can switch db type and see "new tables" and create them all in a few lines of code.

    need a light install? use sqlite, need a hardcore install? install pg, run the app => database and default records created (:

    ReplyDelete
  12. Lars FosdalSeptember 25, 2013 at 5:00 AM

    With databases that run into tens of gigs, hardcore is a must.

    ReplyDelete
  13. Dany MarmurSeptember 27, 2013 at 7:19 AM

    CrossTalk comes with an installer and the eval is really simple to try out. The import utility can show you before "importing" what types it can not handle. If the .net stuff is too convoluted (unmanaged EWS for an example) i usually write the bulk code in VS Express and put some simple interfacing methods that i import and call from Delphi.

    ReplyDelete

Post a Comment