Esempio n. 1
0
 private static List <TeaProfile> GetProfiles()
 {
     TeaProfile[] profiles = new TeaProfile[7];
     for (int i = 1; i <= 7; i++)
     {
         var prof = new TeaProfile((TeaProfile.TeaColorEnum)i, TeaNamesDictionary[i]);
         prof.Name = TeaNamesDictionary[i];
         prof.CaffeineMilligrams = i;
         prof.TeaColor           = (TeaProfile.TeaColorEnum)i;
         profiles[i - 1]         = prof;
     }
     return(profiles.ToList());
 }
Esempio n. 2
0
        static void Main(string[] args)
        {
            WriteLineWithColor("App started.", ConsoleColor.Yellow);
            DocumentStore store = InitializeRavenDbDocumentStore();

            WriteLineWithColor("Document store initialized with " + store.Database + " database.", ConsoleColor.Yellow);

            #region Delete Database

            store.Maintenance.Server.Send(new DeleteDatabasesOperation(store.Database, hardDelete: true));

            #endregion

            #region Create Database

            store.Maintenance.Server.Send(new CreateDatabaseOperation(new DatabaseRecord(DatabaseName)));

            // Prepare indexes (multiple ways to deploy these)
            // new TeaProfile_CaffeineIndex().Execute(store);

            // All classes that inherit from AbstractIndexCreationTask can be deployed at once using one of IndexCreation.CreateIndexes method overloads.
            IndexCreation.CreateIndexes(typeof(Program).Assembly, store);

            #endregion

            #region Store & SaveChanges

            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                List <TeaProfile> teaProfiles = GetProfiles();
                foreach (var profile in teaProfiles)
                {
                    var collectionName = store.Conventions.GetCollectionName(profile);
                    // data only staged into the session, not in the database yet
                    session.Store(profile); // also id and change vector overloads!
                    WriteLineWithColor($"Saved {profile.Name} to session.", ConsoleColor.DarkGreen);
                }

                Stopwatch saveChangesStopwatch = new Stopwatch();
                WriteLineWithColor($"Saving session to database...", ConsoleColor.Yellow);
                saveChangesStopwatch.Start();
                session.SaveChanges();
                saveChangesStopwatch.Stop();
                WriteLineWithColor($"Session persisted database in {saveChangesStopwatch.ElapsedMilliseconds} ms.", ConsoleColor.Green);
            }

            #endregion

            #region Load - https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/loading-entities#load

            WriteLineWithColor($"Moving to Load()", ConsoleColor.Blue);
            TeaProfile loadProfileById = null;
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                string idPrefix = store.Conventions.FindCollectionName(typeof(TeaProfile));
                loadProfileById = session.Load <TeaProfile>(idPrefix + "/" + "Earl Grey");
                WriteLineWithColor($"Loaded {loadProfileById.Name}.  It has {loadProfileById.CaffeineMilligrams} mg of caffeine!", ConsoleColor.Green);
            }

            #endregion

            #region Load Multiple - https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/loading-entities#load---multiple-entities

            WriteLineWithColor($"Moving to LoadMultiple()", ConsoleColor.Blue);
            Dictionary <string, TeaProfile> loadMultipleProfiles = null;
            List <string> idsToFetch = TeaNamesDictionary.Values.ToList();
            for (int i = 0; i < idsToFetch.Count; i++)
            {
                // RavenDB documents its Id building format as such https://ravendb.net/docs/article-page/4.1/csharp/client-api/configuration/identifier-generation/global#identitypartsseparator
                idsToFetch[i] = store.Conventions.FindCollectionName(typeof(TeaProfile)) + store.Conventions.IdentityPartsSeparator + idsToFetch[i];
            }

            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();
                loadMultipleProfiles = session.Load <TeaProfile>(idsToFetch);
                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded {loadMultipleProfiles.Count} profiles in {loadStopwatch.ElapsedMilliseconds} ms. Together, they have a total of {loadMultipleProfiles.Values.Sum(x => x.CaffeineMilligrams)} mg of caffeine!", ConsoleColor.Green);
            }

            #endregion

            #region Load StartingWith - https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/loading-entities#load---multiple-entities

            // Think of this as a way to stream/page the entire dataset with no conditional criteria
            WriteLineWithColor($"Moving to Load StartingWith()", ConsoleColor.Blue);
            TeaProfile[] loadProfilesStartingWith = null;
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                string    prefix        = store.Conventions.FindCollectionName(typeof(TeaProfile));
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();
                loadProfilesStartingWith = session
                                           .Advanced
                                           .LoadStartingWith <TeaProfile>(prefix, null, 0, 50);
                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded {loadProfilesStartingWith.Count()} profiles in {loadStopwatch.ElapsedMilliseconds} ms. Together, they have a total of {loadProfilesStartingWith.Sum(x => x.CaffeineMilligrams)} mg of caffeine!", ConsoleColor.Green);
            }

            #endregion

            #region Basic Document Query - https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#example-i---basic

            // Without where clauses, this is effectively the previous query, SELECT all docs
            WriteLineWithColor($"Moving to Basic Document Query", ConsoleColor.Blue);
            List <TeaProfile> docQueryAllProfiles = null;
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();
                docQueryAllProfiles = session
                                      .Advanced
                                      .DocumentQuery <TeaProfile>()
                                      .WhereGreaterThan(x => x.CaffeineMilligrams, 5)
                                      .ToList();
                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded {docQueryAllProfiles.Count} profiles that have caffeine greater than 5 in {loadStopwatch.ElapsedMilliseconds} ms. Together, they have a total of {docQueryAllProfiles.Sum(x => x.CaffeineMilligrams)} mg of caffeine!", ConsoleColor.Green);
            }

            // More custom methods at https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#custom-methods-and-extensions

            #endregion

            #region Advanced Document Query - https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#example-i---basic

            // Expressing complex queries natively in the C# - eventually these turn into dedicated indexes server-side
            WriteLineWithColor($"Moving to Advanced Document Query", ConsoleColor.Blue);
            List <TeaProfile> docQuerySpecificProfiles = null;
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();
                // tea profiles that aren't white tea, and don't have caffeine above 5
                docQuerySpecificProfiles = session
                                           .Advanced
                                           .DocumentQuery <TeaProfile>()
                                           .WhereNotEquals(x => x.TeaColor, TeaProfile.TeaColorEnum.White)
                                           .AndAlso()
                                           .Not
                                           .OpenSubclause()
                                           .WhereGreaterThan(x => x.CaffeineMilligrams, 5)
                                           .CloseSubclause()
                                           .ToList();
                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded {docQuerySpecificProfiles.Count} tea profiles that aren't white tea, and don't have" +
                                   $" caffeine greater than 5 in {loadStopwatch.ElapsedMilliseconds} ms. {string.Join(",", docQuerySpecificProfiles.Select(x => x.Name))} made " +
                                   $"the list. Together, they have a total of {docQuerySpecificProfiles.Sum(x => x.CaffeineMilligrams)} mg of caffeine!", ConsoleColor.Green);
            }

            // More custom methods at https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#custom-methods-and-extensions

            #endregion

            #region Query against index - https://ravendb.net/docs/article-page/4.1/csharp/indexes/what-are-indexes#basic-example

            WriteLineWithColor($"Moving to Query against index", ConsoleColor.Blue);
            List <TeaProfile> indexedQueryResults = null;
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();
                indexedQueryResults = session
                                      .Query <TeaProfile, TeaProfile_CaffeineIndex>()
                                      .Where(x => x.CaffeineMilligrams < 3)
                                      .ToList();
                loadStopwatch.Stop();
                // or with the advanced stuff
                indexedQueryResults = session
                                      .Advanced
                                      .DocumentQuery <TeaProfile, TeaProfile_CaffeineIndex>()
                                      .WhereBetween(x => x.CaffeineMilligrams, 0, 3)
                                      .ToList();

                WriteLineWithColor($"Loaded {indexedQueryResults.Count} profiles that have caffeine less than 5 in {loadStopwatch.ElapsedMilliseconds} ms. Together, they have a total of {indexedQueryResults.Sum(x => x.CaffeineMilligrams)} mg of caffeine!", ConsoleColor.Green);
            }

            // More custom methods at https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#custom-methods-and-extensions

            #endregion

            #region Query with includes, no index

            WriteLineWithColor($"Moving to Query with include", ConsoleColor.Blue);
            TeaProfile teaProfileForCup = indexedQueryResults.First();
            CupOfTea   cup1             = new CupOfTea()
            {
                PouredOn = DateTime.UtcNow, TeaProfileId = teaProfileForCup.Id, Temperature = 212
            };
            CupOfTea cup2 = new CupOfTea()
            {
                PouredOn = DateTime.UtcNow, TeaProfileId = indexedQueryResults.First(x => x.CaffeineMilligrams > 1).Id, Temperature = 200
            };

            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();

                session.Store(cup1);
                session.Store(cup2);
                session.SaveChanges(); // roundtrip 1

                CupOfTea cup1db = session
                                  .Include <CupOfTea>(x => x.TeaProfileId)
                                  .Load <CupOfTea>(cup1.Id); // roundtrip skipped due to already being loaded in session

                // session will hold and track multiple entities instead of making the full roundtrip
                bool isProfileLoadedFromSession = session.Advanced.IsLoaded(teaProfileForCup.Id); // false

                TeaProfile includedProfile = session.Load <TeaProfile>(cup1db.TeaProfileId);      // loading doc not in session, roundtrip 2

                // this now becomes true, but only 2 roundtrips made (1 for initial save and 1 for read)
                isProfileLoadedFromSession = session.Advanced.IsLoaded(teaProfileForCup.Id);
                int roundtrips = session.Advanced.NumberOfRequests;

                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded document with Include() in {loadStopwatch.ElapsedMilliseconds} ms.", ConsoleColor.Green);
            }

            // More custom methods at https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#custom-methods-and-extensions

            #endregion

            #region Multi doc query with multi include, many-to-many use case

            WriteLineWithColor($"Moving to multi doc query with multi include", ConsoleColor.Blue);
            // reusing objects from above, but instantiating fresh session
            using (IDocumentSession session = store.OpenSession(new SessionOptions()))
            {
                Stopwatch loadStopwatch = new Stopwatch();
                loadStopwatch.Start();

                List <CupOfTea> allCupsOfTeaInDatabase = session
                                                         .Advanced
                                                         .DocumentQuery <CupOfTea>()
                                                         .Include(x => x.TeaProfileId)
                                                         //.Include<CupOfTea>(x => x.TeaProfileId)
                                                         .ToList();
                int roundtrips = session.Advanced.NumberOfRequests;

                // all associated docs in session, still only 1 roundtrip
                var associatedProfiles = session.Load <TeaProfile>(
                    allCupsOfTeaInDatabase
                    .Select(x => x.TeaProfileId)
                    .ToArray())
                                         .ToList();

                roundtrips = session.Advanced.NumberOfRequests;

                loadStopwatch.Stop();
                WriteLineWithColor($"Loaded multiple documents with multi includes in {loadStopwatch.ElapsedMilliseconds} ms.", ConsoleColor.Green);
            }

            // More custom methods at https://ravendb.net/docs/article-page/4.1/csharp/client-api/session/querying/document-query/what-is-document-query#custom-methods-and-extensions

            #endregion


            #region Interrogate document store conventions to assist with calling code

            string conventionCollectionName = store.Conventions.FindCollectionName(typeof(TeaProfile));
            string idPropertyName           = store.Conventions.FindIdentityPropertyNameFromCollectionName("TeaProfiles");
            var    idPropertyMemberInfo     = store.Conventions.GetIdentityProperty(typeof(TeaProfile));
            string idSeparator = store.Conventions.IdentityPartsSeparator; // can also be changed!

            #endregion

            #region LoadStartingWith - multiple executions when underlying Change Vector is different
            #endregion

            Console.ReadKey();

            #region Delete Database

            store.Maintenance.Server.Send(new DeleteDatabasesOperation(store.Database, hardDelete: true));

            #endregion
        }