Example #1
0
        void DoTestAllDataWithDictionaryMultiple()
        {
            bool isSuccess;

            try
            {
                StashClientOptions
                    options = StashConfiguration.GetDefaultOptions();

                AllDataWithDictionaryMultiple(options);                         // use large data must fail

                // if control came here we failed
                isSuccess = false;
            }
            catch (Exception)
            {
                isSuccess = true;
            }

            if (!isSuccess)
            {
                Assert.Fail();
            }


            {
                StashClientOptions
                    options = StashConfiguration.GetDefaultOptions();

                options.SupportLargeObjectsInPool = true;

                AllDataWithDictionary
                    entity = AllDataWithDictionaryMultiple(options);

                // now read without the support large pool options and validate the the entities do NOT match
                //	and the unmapped pool count is different
                options.SupportLargeObjectsInPool = false;

                StashClient <AllDataWithDictionary>
                client = StashConfiguration.GetClient <AllDataWithDictionary>(options);

                AllDataWithDictionary
                    entityRead = client.Get(entity.PartitionKey, entity.RowKey);

                Assert.IsFalse(entityRead.Equals(entity));

                // now read without the support large pool options and validate the the entities DO match
                //	and the unmapped pool count is different
                options.SupportLargeObjectsInPool = true;

                client = StashConfiguration.GetClient <AllDataWithDictionary>(options);

                entityRead = client.Get(entity.PartitionKey, entity.RowKey);

                Assert.IsTrue(entityRead.Equals(entity));

                // delete
                client.Delete(entityRead);
            }
        }
Example #2
0
        AllDataWithDictionaryMultiple(
            StashClientOptions options)
        {
            StashClient <AllDataWithDictionary>
            client = StashConfiguration.GetClient <AllDataWithDictionary>(options);

            AllDataWithDictionary
                entity = TypeFactory <AllDataWithDictionary> .Create(DataSize.Multiple);       // DataSize.Multiple

            client.Insert(entity);

            AllDataWithDictionary
                entityRead = client.Get(entity.PartitionKey, entity.RowKey);

            Assert.IsTrue(entityRead.Equals(entity));

            return(entityRead);
        }
        Tutorial_06_Collections()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create a Stash Client

            StashClient <EmployeeSkills>
            client = StashConfiguration.GetClient <EmployeeSkills>();

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Lets create an instance of the class we what to 'stash'

            const
            string departmentDev = "Dev";

            const
            string ssn = "123456789";

            EmployeeSkills
                dataWritten = new EmployeeSkills {
                Department  = departmentDev,
                EmployeeId  = Guid.NewGuid().ToString(),
                Name        = "John Doe",
                SkillLevel  = 8,
                DateOfBirth = new DateTime(1990, 1, 1),
                SSN         = ssn,
                Salutation  = Salutation.Ms
            };

            // update the private field
            dataWritten.SetAnnualSalary();

            // Populate Languages, certification and salary history
            dataWritten.Languages = new List <ProgramingLanguages> {
                ProgramingLanguages.Assembly,
                ProgramingLanguages.VisualBasic
            };

            const
            string cert0 = "MSSQL",
                   cert1 = "MSCPP",
                   cert2 = "MSRP";

            dataWritten.Certifications = new ArrayList {
                cert0,
                cert1,
                cert2
            };

            dataWritten.SalaryHistory = new SalaryInfo[] {
                new SalaryInfo {
                    DateStart = new DateTime(2009, 1, 1),
                    DateEnd   = new DateTime(2010, 1, 1),
                    Salary    = 100000
                },
                new SalaryInfo {
                    DateStart = new DateTime(2010, 1, 1),
                    DateEnd   = new DateTime(2012, 1, 1),
                    Salary    = 110000
                },
            };

            dataWritten.MysteryNumbers = new int[] { 3, 2, 1, 0 };

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data

            EmployeeSkills
                dataRead = client.Get(dataWritten.Department, dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // Verify exactly what was written to table storage by using the Generic Pool class we wrote
            // earlier.

            // set this up to target the correct table storage entity set
            StashClient <GenericPool>
            clientGenericPool = StashConfiguration.GetClient <GenericPool>(
                new StashClientOptions {
                OverrideEntitySetName          = o => "EmployeeSkills",
                OverrideEntitySetNameIsDynamic = false,
                Feedback = StashConfiguration.TraceFeedback,
            });


            GenericPool
                dataPool = clientGenericPool.Get(
                dataRead.Department,
                dataRead.EmployeeId);

            // All collection items are suffixed with the index base 0, in the format "_000".
            // Because the "_" is used for demarcating collection indexes, explicit defined members are not allowed
            // to have the embedded "_" character in the table property name.

            // Test for languages
            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "Languages_000" &&
                    ((ProgramingLanguages)kv.Value == ProgramingLanguages.Assembly)).ToList().Count == 1);


            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "Languages_001" &&
                    ((ProgramingLanguages)kv.Value == ProgramingLanguages.VisualBasic)).ToList().Count == 1);

            // Test for certification
            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "Certifications_000" &&
                    ((string)kv.Value == cert0)).ToList().Count == 1);

            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "Certifications_001" &&
                    ((string)kv.Value == cert1)).ToList().Count == 1);

            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "Certifications_002" &&
                    ((string)kv.Value == cert2)).ToList().Count == 1);

            // Test salary history - key only
            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "SalaryHistory_000").ToList().Count == 1);

            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "SalaryHistory_001").ToList().Count == 1);

            // Mystery numbers ... well they were persisted using the DataContract Serializer
            // and persisted as XML as a single table property.
            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key == "MysteryNumbers").ToList().Count == 1);

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity

            client.Delete(
                departmentDev,
                dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where   imp.Department == dataWritten.Department &&
                            imp.EmployeeId == dataWritten.EmployeeId
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
Example #4
0
        Tutorial_01_Implicit_JobApplicant()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create the Stash Client.
            // Our helper class offers various flavors of this.

            StashClient <JobApplicant>
            client = StashConfiguration.GetClient <JobApplicant>();

            //----------------------------------------------------------------------------------------------------------
            // Create the corresponding table or confirm that it exists
            // The table name can be inferred using various methods. In this case it is inferred from the class name,
            // 'JobApplicant'.

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Create an instance of the class we want to Stash

            JobApplicant
                dataWritten = new JobApplicant {
                PartitionKey = "A",
                RowKey       = Guid.NewGuid().ToString(),
                Name         = "John Doe",
                Skill_Level  = 1
            };

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data, using the partition and row key, no need to use LINQ here.

            JobApplicant
                dataRead = client.Get(dataWritten.PartitionKey, dataWritten.RowKey);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // Lets change the SkillLevel and Update

            dataWritten.Skill_Level += 1;

            client.Update(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data but this time lets use LINQ

            dataRead = client.CreateQuery()
                       .Where(imp => imp.PartitionKey == dataWritten.PartitionKey &&
                              imp.RowKey == dataWritten.RowKey)
                       .FirstOrDefault();

            //----------------------------------------------------------------------------------------------------------
            // Again verify that we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity

            client.Delete(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where   imp.PartitionKey == dataWritten.PartitionKey &&
                            imp.RowKey == dataWritten.RowKey
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
Example #5
0
        Tutorial_03_Explicit_Employee()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create the Stash Client.

            StashClient <Employee>
            client = StashConfiguration.GetClient <Employee>();

            //----------------------------------------------------------------------------------------------------------
            // Create the underlying table if it does not already exists

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Create an instance of the class

            const
            string departmentDev = "Dev";

            Employee
                dataWritten = new Employee {
                Department  = departmentDev,
                EmployeeId  = Guid.NewGuid().ToString(),
                Name        = "John Doe",
                SkillLevel  = 8,
                DateOfBirth = new DateTime(1990, 1, 1)
            };

            // update the private field
            dataWritten.SetAnnualSalary();

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            // Note: On inserts, updates and merges, the ETag is overwritten from the ETag returned to keep the data
            // in sync.

            //----------------------------------------------------------------------------------------------------------
            // And read it back

            Employee
                dataRead = client.Get(dataWritten.Department, dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            // Verify that the 2 ETags are identical
            Assert.IsTrue(dataRead.ETagInternal == dataWritten.ETagInternal);

            //----------------------------------------------------------------------------------------------------------
            // Change the Skill level and update the Stash

            dataWritten.SkillLevel += 1;

            dataWritten.SetAnnualSalary();

            client.Update(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data but this time lets use LINQ

            Employee
                dataReadUpdated = client.CreateQuery()
                                  .Where(imp => imp.Department == departmentDev &&
                                         imp.EmployeeId == dataWritten.EmployeeId)
                                  .FirstOrDefault();

            //----------------------------------------------------------------------------------------------------------
            // Again verify that we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataReadUpdated));

            // Verify that the 2 ETags are identical
            Assert.IsTrue(dataWritten.ETagInternal == dataReadUpdated.ETagInternal);

            //----------------------------------------------------------------------------------------------------------
            // now attempt to update the data read the first time around
            // this should fail and throw an exception since the data was updated since the row was last read and
            // so has a stale ETag.
            // Uses the implied update mode here by default. That is, if the StashETag attribute is applied to a
            // member in the class, implies ETag must match,

            bool isSuccess;

            try
            {
                client.Update(dataRead);

                isSuccess = false;
            }
            catch (Exception ex)
            {
                Assert.IsTrue((ex as StashException).Error == StashError.ETagMatchFailed);

                isSuccess = true;
            }

            Assert.IsTrue(isSuccess);

            //----------------------------------------------------------------------------------------------------------
            // attempt to update it again but this time ignore ETag matching. This should succeed.
            // and dataRead has the latest ETag

            client.UpdateUnconditional(dataRead);

            //----------------------------------------------------------------------------------------------------------
            // now attempt to delete the entity using the data written entity
            // this should fail and throw an exception since the data was recently updated and so has a new ETag
            // Uses the implied update mode here by default. That is, if the StashETag attribute is applied to a
            // member in the class, implies ETag must match,

            try
            {
                client.Delete(dataReadUpdated);

                isSuccess = false;
            }
            catch (Exception ex)
            {
                Assert.IsTrue((ex as StashException).Error == StashError.ETagMatchFailed);

                isSuccess = true;
            }

            Assert.IsTrue(isSuccess);

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity unconditionally without the need for ETag Matching.
            // Can instead also use client.DeleteUnconditional here too.

            client.Delete(dataRead, ETagMatch.Unconditional);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where       imp.Department == dataWritten.Department &&
                            imp.EmployeeId == dataWritten.EmployeeId
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // Essentially the ETag gist is this.
            // Define and decorate a member in your type with an ETag if you want to optimistic concurrency support.
            //   Stash will keep you ETag in sync across inserts, updates and merges.
            //   There are multiple ways to implicitly override ETag matching if that is what is wanted.
            // The implicit way to disable optimistic concurrency support is not to define an ETag member.

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
        Tutorial_04_DictionaryPool()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create a Stash Client for the Employee class

            StashClient <Employee>
            clientEmployee = StashConfiguration.GetClient <Employee>();

            clientEmployee.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Create an StashClient for the generic pool class,
            // Since we want to read and write to the Employee table, notice how we setup the correct EntityName in
            // the StashClientOptions. Otherwise the azure table implied would be "GenericPool".
            //
            // The call back method of naming the table has flexible capabilities. It can be used to determine
            // the table name dynamically based on the data in the object instance.
            // In this case it is used statically and called only once.

            StashClient <GenericPool>
            clientGenericPool = StashConfiguration.GetClient <GenericPool>(
                new StashClientOptions {
                OverrideEntitySetName          = o => "Employee",
                OverrideEntitySetNameIsDynamic = false,
                Feedback = StashConfiguration.TraceFeedback,
            });

            //----------------------------------------------------------------------------------------------------------
            // Stash an Employee

            const
            string departmentDev = "Dev";

            Employee
                dataEmployee = new Employee {
                Department  = departmentDev,
                EmployeeId  = Guid.NewGuid().ToString(),
                Name        = "John Doe",
                SkillLevel  = 8,
                DateOfBirth = new DateTime(1990, 1, 1)
            };

            dataEmployee.SetAnnualSalary();

            clientEmployee.Insert(dataEmployee);

            //----------------------------------------------------------------------------------------------------------
            // and read it back thru the GenericPool

            GenericPool
                dataPool = clientGenericPool.Get(
                dataEmployee.Department,
                dataEmployee.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in via the Employee type.

            Assert.IsTrue(
                dataPool.PrimaryKey == dataEmployee.Department &&
                dataPool.SecondaryKey == dataEmployee.EmployeeId &&
                dataPool.Pool["AnnualSalary"].Equals(dataEmployee.GetAnnualSalary()) &&
                dataPool.Pool["Birthday"].Equals(dataEmployee.DateOfBirth) &&
                dataPool.Pool["SkillLevel"].Equals(dataEmployee.SkillLevel) &&
                dataPool.Pool["Name"].Equals(dataEmployee.Name) &&
                dataPool.Pool.Count == 4 + 1);                                                                  // + 1 to the ETag

            //----------------------------------------------------------------------------------------------------------
            // Make a few changes and update

            dataPool.Pool["Name"]   = "Lucifure";                               // name change
            dataPool.Pool["Unique"] = Guid.NewGuid();                           // new field

            clientGenericPool.Update(dataPool);

            // Note: Updates, Merges etc keep the original objects in sync with the latest ETags.
            // Even if an ETag is not specified for the type, if the type supports a Pool,
            // the ETag is maintained and synched in the pool

            //----------------------------------------------------------------------------------------------------------
            // Read back the data

            GenericPool
                dataPoolRead = clientGenericPool.CreateQuery()
                               .Where(imp => imp.PrimaryKey == dataEmployee.Department &&
                                      imp.SecondaryKey == dataEmployee.EmployeeId)
                               .FirstOrDefault();

            //----------------------------------------------------------------------------------------------------------
            // and verify that we got back what we put in

            Assert.IsTrue(
                dataPool.PrimaryKey == dataPoolRead.PrimaryKey &&
                dataPool.SecondaryKey == dataPoolRead.SecondaryKey &&
                StashHelper.DictionaryEquals(
                    dataPool.Pool,
                    dataPoolRead.Pool));

            //----------------------------------------------------------------------------------------------------------
            // Merge can be performed very efficiently with a StashPool. Only include the tables properties
            // to be merge in the dictionary. No need to null out members or defined nullable value type members.

            // Create a new pool with just the objects of interest
            Dictionary <string, object>
            pool = new Dictionary <string, object>();

            // save the current etag (for now and later)
            string
                etagPreMerge = dataPoolRead.Pool[Literal.ETag].ToString();

            pool["Name"]       = "Stash";                                                                               // new value to merge
            pool[Literal.ETag] = etagPreMerge;                                                                          // get the ETag too

            // create a new pool object for merging.
            GenericPool
                dataPoolMerged = new GenericPool {
                PrimaryKey   = dataPoolRead.PrimaryKey,
                SecondaryKey = dataPoolRead.SecondaryKey,
                Pool         = pool
            };

            clientGenericPool.Merge(dataPoolMerged, ETagMatch.Must);                            // force ETag matching.

            // read back and verify
            GenericPool
                dataPoolMergedRead = clientGenericPool.Get(
                dataPoolMerged.PrimaryKey,
                dataPoolMerged.SecondaryKey);

            // validate
            Assert.IsTrue(dataPoolMergedRead.Pool.Count == dataPoolRead.Pool.Count &&
                          dataPoolMergedRead.Pool["Name"] as String == "Stash");

            //----------------------------------------------------------------------------------------------------------
            // attempt to merge again, replacing the current ETag with the old one.

            bool isSuccess;

            try
            {
                // use the defunct etag to exhibit this
                dataPoolMerged.Pool[Literal.ETag] = etagPreMerge;

                clientGenericPool.Merge(dataPoolMerged);

                isSuccess = false;
            }
            catch (Exception ex)
            {
                // Merge fails because the ETag was old and did not match.
                Assert.IsTrue((ex as StashException).Error == StashError.ETagMatchFailed);

                isSuccess = true;
            }

            Assert.IsTrue(isSuccess);

            //----------------------------------------------------------------------------------------------------------
            // attempt to merge yet again, this time by disabling ETag matching.

            clientGenericPool.Merge(dataPoolMerged, ETagMatch.Unconditional);

            //----------------------------------------------------------------------------------------------------------
            // now attempt to delete the entity

            try
            {
                clientGenericPool.Delete(dataPoolMergedRead);                           // Implicit ETag matching, will make this fail too
                // because the last update changed the ETag
                isSuccess = false;
            }
            catch (Exception ex)
            {
                Assert.IsTrue((ex as StashException).Error == StashError.ETagMatchFailed);

                isSuccess = true;
            }

            Assert.IsTrue(isSuccess);

            //----------------------------------------------------------------------------------------------------------
            // Do an unconditional delete

            clientGenericPool.DeleteUnconditional(dataPoolMergedRead);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from emp in clientEmployee.CreateQuery()
                            where   emp.Department == dataEmployee.Department &&
                            emp.EmployeeId == dataEmployee.EmployeeId
                            select emp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
Example #7
0
        Tutorial_07_LargeData()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create Stash Client

            StashClient <EmployeeResume>
            client = StashConfiguration.GetClient <EmployeeResume>();

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Lets create an instance of the class we what to 'stash'

            const
            string departmentDev = "Dev";

            EmployeeResume
                dataWritten = new EmployeeResume {
                Department = departmentDev,
                EmployeeId = Guid.NewGuid().ToString(),

                // 1 char = 2 bytes so this random string is 2.5 time the size of a table property
                Text = BuildString((int)(32 * 1024 * 2.5)),

                // almost 2 time the size of a table property
                Photograph = new byte[(int)(64 * 1024 * 1.9)],
            };

            // generate random bytes for the photograph
            (new Random()).NextBytes(dataWritten.Photograph);

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data

            EmployeeResume
                dataRead = client.Get(dataWritten.Department, dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // Verify exactly what was written to table storage by using the Generic Pool class we wrote
            // earlier.

            // set this up to target the correct table storage entity set
            StashClient <GenericPool>
            clientGenericPool = StashConfiguration.GetClient <GenericPool>(
                new StashClientOptions {
                OverrideEntitySetName          = o => typeof(EmployeeResume).Name,
                OverrideEntitySetNameIsDynamic = false,
                Feedback = StashConfiguration.TraceFeedback,
            });


            GenericPool
                dataPool = clientGenericPool.Get(
                dataRead.Department,
                dataRead.EmployeeId);

            // All split items are suffixed with the index base A, in the format "_A".
            // Because the "_" is used for demarcating collection indexes, explicit defined members are not allowed
            // to have the embedded "_" character in the table property name.

            // Test for Text
            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key.IndexOf("Text_") == 0).ToList().Count == 3);

            Assert.IsTrue(
                dataPool.Pool.Where(
                    kv =>
                    kv.Key.IndexOf("Photograph_") == 0).ToList().Count == 2);

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity

            client.Delete(
                departmentDev,
                dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where   imp.Department == dataWritten.Department &&
                            imp.EmployeeId == dataWritten.EmployeeId
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
Example #8
0
        Tutorial_05_Morphing_EmployeeInfo()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create a Stash Client

            StashClient <EmployeeInfo>
            client = StashConfiguration.GetClient <EmployeeInfo>();

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Create an instance of the class we what to Stash

            const
            string departmentDev = "Dev";

            const
            string ssn = "123456789";

            EmployeeInfo
                dataWritten = new EmployeeInfo {
                Department  = departmentDev,
                EmployeeId  = Guid.NewGuid().ToString(),
                Name        = "John Doe",
                SkillLevel  = 8,
                DateOfBirth = new DateTime(1990, 1, 1),
                SSN         = ssn,
                Salutation  = Salutation.Dr
            };

            // update the private field
            dataWritten.SetAnnualSalary();

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data

            EmployeeInfo
                dataRead = client.Get(dataWritten.Department, dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // Now let us verify exactly what was written to table storage by using the Generic Pool class we wrote
            // earlier.

            // set this up to target the correct table storage entity set
            StashClient <GenericPool>
            clientGenericPool = StashConfiguration.GetClient <GenericPool>(
                new StashClientOptions {
                OverrideEntitySetName          = o => "EmployeeInfo",
                OverrideEntitySetNameIsDynamic = false,
                Feedback = StashConfiguration.TraceFeedback,
            });


            GenericPool
                dataPool = clientGenericPool.Get(
                dataRead.Department,
                dataRead.EmployeeId);

            // validate that the SSN value got morphed in to a byte[]
            Assert.IsTrue(dataPool.Pool["SSN"].GetType() == typeof(byte[]));

            //----------------------------------------------------------------------------------------------------------
            // Change the Skill level and update the Stash

            dataWritten.SkillLevel += 1;

            dataWritten.SetAnnualSalary();

            // force an unconditional update since, dataWritten does not have a ETag.
            // Optionally copy over the ETag from dataRead.
            client.Update(dataWritten, ETagMatch.Unconditional);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data but this time lets use LINQ

            dataRead = client.CreateQuery()
                       .Where(imp => imp.Department == departmentDev &&
                              imp.EmployeeId == dataWritten.EmployeeId)
                       .FirstOrDefault();

            //----------------------------------------------------------------------------------------------------------
            // Again verify that we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity

            client.Delete(
                departmentDev,
                dataWritten.EmployeeId);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where   imp.Department == dataWritten.Department &&
                            imp.EmployeeId == dataWritten.EmployeeId
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }
Example #9
0
        Tutorial_02_Hybrid_TempHire()
        {
            //----------------------------------------------------------------------------------------------------------
            // Create the Stash Client.

            StashClient <TempHire>
            client = StashConfiguration.GetClient <TempHire>();

            //----------------------------------------------------------------------------------------------------------
            // Create a table with the class name ('TempEmployee') or confirm that it exists

            client.CreateTableIfNotExist();

            //----------------------------------------------------------------------------------------------------------
            // Create an instance of the class we what to Stash

            TempHire
                dataWritten = new TempHire {
                PartitionKey = "B",
                RowKey       = Guid.NewGuid().ToString(),
                Name         = "Jill Doe",
                Skill_Level  = 5,
                DateOfBirth  = new DateTime(1990, 1, 1)
            };

            // update the private field
            dataWritten.SetHourlyPay();

            //----------------------------------------------------------------------------------------------------------
            // Stash it

            client.Insert(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data

            TempHire
                dataRead = client.Get(dataWritten.PartitionKey, dataWritten.RowKey);

            //----------------------------------------------------------------------------------------------------------
            // Verify we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // Lets change the Skill level and update the Stash

            dataWritten.Skill_Level += 1;

            dataWritten.SetHourlyPay();

            client.Update(dataWritten);

            //----------------------------------------------------------------------------------------------------------
            // Read back the data but this time lets use LINQ

            dataRead = client.CreateQuery()
                       .Where(imp => imp.PartitionKey == dataWritten.PartitionKey &&
                              imp.RowKey == dataWritten.RowKey)
                       .FirstOrDefault();

            //----------------------------------------------------------------------------------------------------------
            // Again verify that we got back what we put in

            Assert.IsTrue(dataWritten.Equals(dataRead));

            //----------------------------------------------------------------------------------------------------------
            // now delete the entity

            client.Delete(
                dataWritten.PartitionKey,
                dataWritten.RowKey);

            //----------------------------------------------------------------------------------------------------------
            // And verify that it was actually deleted
            // by attempting to read back the data

            var queryable = from imp in client.CreateQuery()
                            where       imp.PartitionKey == dataWritten.PartitionKey &&
                            imp.RowKey == dataWritten.RowKey
                            select imp;

            Assert.IsTrue(queryable.ToList().Count == 0);

            //----------------------------------------------------------------------------------------------------------
            // So far so good. This concludes this part of the tutorial. Go Stash!
        }