Beispiel #1
0
 public SQL_CRUD(DocumentClient client, String dbName, String collName, docObject doc = null)
 {
     this.client   = client;
     this.dbName   = dbName;
     this.collName = collName;
     this.doc      = doc;
 }
Beispiel #2
0
        public async Task upsertDocuments(docObject doc)  //To Upsert/Insert Documents Documents to the CosmosDB
        {
            Uri docUri = UriFactory.CreateDocumentCollectionUri(dbName, collName);

            try
            {
                ResourceResponse <Document> response = await client.UpsertDocumentAsync(docUri, doc);

                Console.WriteLine(response.RequestDiagnosticsString);
            }
            catch (Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
Beispiel #3
0
        static void Main(string[] args)
        {
            ConnectionPolicy connectionPolicy = new ConnectionPolicy();

            connectionPolicy.ConnectionMode     = ConnectionMode.Direct;
            connectionPolicy.ConnectionProtocol = Protocol.Tcp;

            DocumentClient client = new DocumentClient(new Uri("<ENDPOINT_FROM_PORTAL>"),
                                                       "PRIMARY_KEY_FROM_PORTAL");

            /*
             *
             * Creating and Updating Stored Procedures in SQL API CosmosDB. Need to still DELETE, EXECUTE
             * This code displays the sproc function body after create or update.
             *
             */
            SQL_Sprocs sprocs  = new SQL_Sprocs(< DATABASE_NAME >, <COLLECTION_NAME>, client);
            string     sprocId = < SPROC_NAME >;

            //Modify the Values in the Above Object creation call and sproc Name
            //Create the Sproc. Created a dummy sproc here.
            sprocs.createSproc(sprocId, "function () { getContext().getResponse().setBody('Hello Bob!'); }").Wait();

            //Read a Stored Procedure
            sprocs.readSproc(sprocId).Wait();

            //Update the Sproc
            sprocs.updateSproc(sprocId, "function (text) { getContext().getResponse().setBody('Hello ' + text + '!!'); }").Wait();

            //Execute the Sproc
            sprocs.executeSproc(sprocId).Wait();

            //Delete a Sproc
            sprocs.deleteSproc(sprocId).Wait();

            /*
             *
             * All CRUD Operations from here
             * Documents are under docObject class(format is available there)
             * Use upserts for inserts as well
             *
             */
            SQL_CRUD sqlCrud = new SQL_CRUD(client, <DATABASE_NAME>, <COLLECTION_NAME>);

            //Creating a Database
            sqlCrud.createDatabaseIfNotExists().Wait();

            //Creating a Collection
            sqlCrud.createCollectionIfNotExists(400).Wait();

            //Executing a Query
            sqlCrud.executeSqlQuery("SELECT VALUE COUNT(1) as Value_1 FROM c").Wait();

            //Upserting/Inserting a document( Run over a for loop to Insert/Upsert a lot of docs or use the Bulk Executor's BulkUpdate API )
            //Added Test Values here.
            docObject doc = new docObject()
            {
                city    = "Bangalore",
                id      = "6",
                Value_1 = 22,
                Value_2 = 10
            };

            sqlCrud.upsertDocuments(doc).Wait();

            //Deleting a document ( Run over a for loop to delete a lot of docs or use the Bulk Executor BulkDelete API )
            //( id, partitionKeyValue )
            sqlCrud.deleteDocuments("6", "Bangalore").Wait();

            Console.ReadKey();
        }