mORMot Open Source

aruncs08

Member

Registered: 2014-10-13

Posts: 27

mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

Hi,

I am new to this Framework in Delphi XE7. Can anyone help me with the startup?

Question: How to populate some data in a grid from MS SQL database using mORMot framework?

It will be good if any, simple examples available.

Thanks in advance.

Last edited by aruncs08 (2014-10-15 12:54:28)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

To be honnest, if you want to "populate some data in a grid from MS SQL database", you do not need an ORM, nor a SOA framework.
Just use RAD components!

The main purpose of mORMot is to use an ORM to define the database, then either SOA or remote REST operations to retrieve the information.
Take a look at sample "28 - Simple RESTful ORM Server" and "17 - TClientDataset use".

aruncs08

Member

Registered: 2014-10-13

Posts: 27

Re: mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

Thanks for your reply.

Actually, I want to get practice with mORMot framework. I don't know how to define the database (in my case MS SQL) using ORM, any idea to start from scratch?

I will also look at the samples which you have mentioned.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

Please download the latest 1.18 "unstable" version of the framework.
Then take a little time to browse the beginning of the SAD 1.18 pdf, where you would find a lot of info.

Sample "28 - Simple RESTful ORM Server" defines a simple ORM server, with an external database.

aruncs08

Member

Registered: 2014-10-13

Posts: 27

Re: mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

Ok! Thanks, I will let you know if it works.

aruncs08

Member

Registered: 2014-10-13

Posts: 27

Re: mORMot framework(a newbie) with MS SQL connection in Delphi XE7!

Hi Again!

In that sample "28 - Simple RESTful ORM Server", they have PostgreSQL connection by default and that doesn't work for me.

Can you tell me, what I need to change in that sample 28 for MS SQL database instead of PostgreSQL? So that I can try to understand, if it works.

Thanks in advance.