SQL Queries

Why SQL?

Our database uses SQL - familiar yet powerful query language with intuitively obvious extensions. Millions of professionals use SQL in their everyday work. Developers in your company know SQL, we are sure. Then they know Eloquera Database.

SQL is not only a programming language; it is a tool for looking through and analyzing data.

Eloquera Database supports queries to object’s fields and properties, to child objects, to the arrays and the arrays of objects. It is immensely powerful.

General query syntax

SELECT [SKIP count][TOP count] TypeName

[WHERE {Expression [AND|OR] }[..n]]

[ORDER BY {Expression}[,] [ASC|DESC]}[..n]]

A common query may looks like this

//Create parameters

Parameters param = db.CreateParameters();

//Simple type parameter

param["genre"] = 5;

Movie m = (Movie)db.ExecuteScalar("SELECT Movie WHERE Genre >= @genre", param);

Or more sophisticated queries

db.ExecuteQuery("SELECT Movie WHERE Genre = 1");

db.ExecuteQuery("SELECT Cinema WHERE Movies.Title = 'Die Hard 4'");

db.ExecuteQuery("SELECT Cinema WHERE Movies.Studios.Titles CONTAINS '20th Century Fox'");

db.ExecuteQuery("SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'");

db.ExecuteQuery("SELECT Cinema WHERE '20th Century Fox' IN Movies.Studios.Titles");

db.ExecuteQuery("SELECT Cinema WHERE OpenDates BETWEEN['en-US'] '10/1/2006' AND '9/17/2009'");

db.ExecuteQuery("SELECT SKIP 6 JoinClassA, JoinClassB FROM JoinClassA JOIN JoinClassB ON JoinClassA.id = JoinClassB.id INNER JOIN JoinClassC ON JoinClassA.id = JoinClassC.id");