Eloquera 2.0オブジェクトデータベース

Eloqueraオブジェクトデータベースの2番目のバージョンのリリースは、来月に予定されています。 特別なことは何もないようです-週に何回リリースされるかわかりません。



しかし、エロケラの狂ったロシア人プログラマーのグループは、少し実験をすることにしました。 会社の経営陣との協議の議論と乱用の後、Eloqueraに所属していないプロのプログラマーのグループに特定のベースビルドへのアクセスを許可することが決定されました。 なんで? 「scられる」/「賞賛する」というテーマについて、また「無料の鳥」がベースを使用し、通常のテスターのチームよりも個々の欠点を見つけるのに効果的であることを証明する。 まあ、そして狂ったロシア人は不可能を発明することを示すために-それはただ素晴らしいです:-)



Eloqueraは、.NET 2.0以降のクライアントサーバーオブジェクトデータベースであり、クエリをサポートする独自のデータストレージとインデックスエンジンを備えていることを思い出してください。



最初に-



Eloquera 2.0の機能の短いリスト





JOINがサポートするオブジェクトベースなど、多くのことがありますか? そして配列? そのため、Eloquera 2.0の機能に関する一連の出版物を作成し、オブジェクトベースのプログラミングのさまざまな側面について説明することにしました。 最初に見たい記事についてご意見をお聞かせいただければ幸いです。 トピックは上にリストされています。



これをすべて適用する方法をすばやく理解するために、データベースを操作するためのサンプルコードを示します。



  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 ( ) ) ; } }



  6. // - . 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 ( ) ) ; } }



  12. // - . 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 ( ) ) ; } }



  15. // - . 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 ( ) ) ; } }



  18. // - . 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 ( ) ) ; } }



  23. // - . 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 ( ) ) ; } }



  26. // - . 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 ( ) ) ; } }







Eloquera 2.0の使用を開始するには?



最初の方法は、 Eloquera 2.0のコードネームWoomeraをダウンロードしてインストールすることです(ところで、 woomeraとは何ですか?)。 32ビットおよび64ビットシステム用のオプションがあります。 私たちが求めるのは登録することだけです。 原則として、電子メール以外のフィールドは必須ではないため、単純に電子メールアドレスを入力できます。 しかし、誰かが個人的に宛てられた手紙を受け取るのがより快適な場合は、あなたの名前を追加してください-後で私たちのプログラマーが新しいリリースに関して個人的にあなたに書いて-一般的には通信します また、応答として、データベースやその他の便利なものをダウンロードするためのリンクが記載された電子メールを受け取るため、電子メールが必要です。



2つ目は、データベースに接続する権利を自分自身に与えることです。 ローカルマシンの管理者であれば、何もする必要はありません。 科学に従ってすべてを行う場合(これは大歓迎です!)、グループまたはユーザーをサーバー上の許可リストに追加します。 これを行う方法- ドキュメント 、より具体的には、このページをご覧ください 。 最も簡単な方法は、Usersグループを許可リストに追加することです(ちなみに、この設定はロシア語のOSがインストールされていても機能します。このようなグループは「Users」と呼ばれます)。 その後-サーバーを再起動します。 コマンドラインからは、次のようになります



net stop "Eloquera Server 2.0"

net start "Eloquera Server 2.0"







もちろん、この出版物がEloqueraデータベースの新しいバージョンの完全なレビューであると主張しているわけではありませんが、それでも私たちの開発をダウンロードして実際に試す良い理由として役立つことを願っています。




All Articles