Posts

Showing posts with the label sql

I updated the documentation to reflect the latest state of our Open Source framework, for creating state-of-the-art CQRS Persistence Services in Delphi, following DDD best practices.

I updated the documentation to reflect the latest state of our Open Source framework, for creating state-of-the-art CQRS Persistence Services in Delphi, following DDD best practices. You can persist any kind of class, even complex with nested class instances, with no need to inherit from a fixed parent class, then store the content in most SQL or NoSQL engines using the framework ORM core. The fact that persistence is defined as interface services also features direct stubing/mocking of it, for easy unit testing of your precious business code. And you could access this persistence service remotely, via a JSON REST access point, if needed. #DDD   #CQRS   #Delphi   #ORM   #ODM   #MongoDB   #SQL   #NoSQL   #SOA   #OpenSource   #mORMot   http://blog.synopse.info/post/2015/05/18/CQRS-Persistence-Service-of-any-DDD-object-with-mORMot

ADO - Stored Procedure - Generated SQL

ADO - Stored Procedure - Generated SQL Is there a way to intercept and view the generated SQL of a stored procedure call? We have a strange date off by 2 issue. #sql

Migration from MSSQL to PostgreSQL?

Migration from MSSQL to PostgreSQL? Has anyone of you done this? There are features that you pay mucho dollars for in MSSQL, which PostgreSQL appears to manage just fine. #sql

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