Eloquera 2.0 Object Database

The release of the second version of the Eloquera object database is scheduled for next month. Nothing fancy, it seems, few releases happen weekly.

But a group of crazy Russian programmers from Eloquera decided to do a little experiment. After some disputes and swearing consultations with the management of the company, it was decided to give access to individual builds of the database to a group of professional programmers not connected with Eloquera. What for? On the subject of "scold" / "praise", as well as prove that the "free birds" will be more effective in using the base and finding individual shortcomings than the full-time team of testers. Well, and to show that crazy Russians are inventive to impossibility - which is just wonderful. :-)

Recall that Eloquera is a client-server object database for .NET 2.0 and higher, with its own data storage and indexing engine, supporting queries.
')
At first -

A short list of features Eloquera 2.0

• Storing C # objects (and generally any .NET-languages) without any transformation or implementation of interfaces.
• Queries in SQL. No SQL database needed.
• Return of objects in their original form (in the form of transfers or one by one).
• Support for arrays and list parameters in SQL. Arrays can be multidimensional and jagged - the syntax is one.
• JOINs in queries - yes, for any fields, including arrays!
• Functions and expressions in queries - according to them you can make JOINs and sort them.
• Standard and not very standard sorting.
• Regular expressions in queries - Reg Ex forever!
• Indices - the usual such indices, to speed up queries.
• Support for mass insert / update objects (tens of thousands of objects less than a second)
• Support for generic objects.
• Inheritance in queries (SELECT ParentClass returns both ParentClass and ChildClass)
• Requests for a specific type (SELECT ONLY ParentClass returns only ParentClass, but not ChildClass)
• The possibility of partial restoration of objects (if you need a ForumTopic object, you can not pull all the TopicMessage associated with it)
• Specifying the “depth” of the query - return only A? Or A and all ABC? Or all related objects?
• Client-server mode
• Simultaneous work of multiple users (requests are executed in parallel and independently).
• Authentication through Windows accounts (or no user at all - then the active user account will be used)
• Server and client implementation in 32-bit and 64-bit versions.
• The unique identifier of each object - to work in a stateless environment (of course, for ASP.NET)
• Support for different cultures (for example, where dates BETWEEN ['en-US'] @ d1 and @ d2 - American formats will be accepted, even if you work on Russian Windows)
• Approximate search by ALMOST operator

There are a lot of things, for example, which object base supports JOINs? And the arrays? Therefore, we decided to make a series of publications about the possibilities of Eloquera 2.0, talking about various aspects of programming for our object base. We will be glad if you express your thoughts on which articles you would like to see first. Topics - in the list above.

In order to quickly understand how to apply all this, here is an example code for working with a database:

1. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
2. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
3. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
4. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
5. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
7. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
8. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
9. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
10. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
11. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
13. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
14. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
16. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
17. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
19. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
20. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
21. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
22. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
24. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
25. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
27. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
28. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
29. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
30. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
31. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }
32. // - . using ( DB db = new DB ( "server=localhost;options=none;" ) ) { // . db. OpenDatabase ( "Cinemas" ) ; // . Cinema cinema = new Cinema ( ) { Location = "Sydney" , OpenDates = new DateTime [ ] { new DateTime ( 2003 , 12 , 10 ) , new DateTime ( 2003 , 10 , 3 ) } } ; // . db. Store ( cinema ) ; // - . var kino = db. ExecuteQuery ( "SELECT Cinema WHERE ALL Movies.Studios.Titles CONTAINS '20th Century Fox'" ) ; // Parameters param = db. CreateParameters ( ) ; param [ "dt1" ] = new DateTime ( 2006 , 10 , 1 ) ; param [ "dt2" ] = new DateTime ( 2009 , 09, 17 ) ; // , OpenDates . var result = db. ExecuteQuery ( "SELECT Cinema WHERE OpenDates BETWEEN @dt1 AND @dt2" , param ) ; // - . foreach ( var cinema in result ) { Console. WriteLine ( cinema. ToString ( ) ) ; } }

How to get started with Eloquera 2.0?

The first is to download and install Eloquera 2.0 codename Woomera (by the way, do you know what woomera is ?). There are options for 32-bit and 64-bit systems. The only thing we ask is to register . In principle, no field other than e-mail is mandatory, so you can simply enter your email address. But if it is more pleasant for someone to receive letters addressed personally to him or her, then add your name - and later one of our programmers will personally write to you on the subject of new releases and - generally communicate. And e-mail is needed, because in response you will receive a letter with links to download the database and other useful things.

The second is to give yourself the right to connect to the database. If you are an administrator on a local machine, then you don’t need to do anything. If you are doing everything according to science (which we warmly welcome!), Then add your group or your user to the list of allowed on the server. How to do this - you can see in the documentation , more specifically - on this page . The easiest way is to add the Users group to the allowed list (by the way, this setting will work even if you have an OS installed in Russian, in which such a group is called “Users”). After that - restart the server. From the command line it looks like

net stop "Eloquera Server 2.0"
net start "Eloquera Server 2.0"

Of course, this publication does not claim to be the full review of the new version of the Eloquera database, but I hope it will still be a good reason to download and try our development in action.