Sitecore, Asp.Net,C#, SQL Server

Answer of Quiz 11  Week 4   is given below MongoDB  of  Index Creation, Background.

Answer of Quiz 10  Week 4   is given below MongoDB  of  Index Creation, Sparse.

Answer of Quiz 9  Week 4   is given below MongoDB  of  Index Creation Option, Unique. Command of mongo shell to create index on student_id,class_id ascending of the student collection. Command is : -   db.students.createIndex( {"student_id" : 1, "class_id" : 1 }, { "unique" : true } );

Answer of Quiz 8  Week 4   is given below MongoDB  of  Dot Notation and Multikey. Command in the shell of MongoDB to create an index on the company descending is give below. Ans :-  db.people.createIndex( { "work_history.company" : -1 } );

Answer of Quiz 7  Week 4   is given below MongoDB  of Multikey Indexes.

Answer of Quiz 6  Week 4   is given below MongoDB  of  Discovering (and Deleting) Indexes.

Answer of Quiz 5  Week 4   is given below of MongoDB  to Creating Indexes. Query to create index in MongoDB is. Here students is collection in mongodb. db.students.createIndex( { "class" : 1, "student_name" : 1 } )

Answer of Quiz 4  Week 4   is given below of MongoDB  of Indexes.

Answer of Quiz 3  Week 4   is given below of MongoDB  of Storage Engines: WiredTiger.

Answer of Quiz 2  Week 4   is given below MongoDB  of Storage Engines: MMAPv1.

Answer of Quiz 1  Week 4   is given below of MongoDB  of Storage Engines.

Answer of Quiz 7 is given below of MongoDB  Trees .

Answer of Quiz 6 is given below of MongoDB One to Many Relations.

Answer of Quiz 5 is given below of Mongodb One to One Relations.

Answer of Quiz 3 is given below of Mongo Living Without Transactions.

Answer of Quiz 3 is given below of Mongo Living Without Constraints.

Answer of MongoDB Quiz 2 of week 3 for .Net Developers. Data access pattern is not supported by blog schema is "Providing a table of contents by tag".

Answer of MongoDB Quiz 1 of week 3 for .net developer on schema design is given below in image.

MongoDB Homework 3.1 for the .Net Development is given below step by step. Step1 :Download student.json from Download handout which is in homework url. Use the below command to drop and import new data of student in MongoDB by using mongoimport command. mongoimport --drop -d school -c students students.json There should be two hundred record in the student collection. First check the data which is correctly imported or not. see below command which help to find data in MongoDB collections use school db.students.count() Correct output of count will be two hundred. Now we need to find the student with highest average in the class . Use below query to get answer. db.students.aggregate( [ { '$unwind': '$scores' }, { '$group': { '_id': '$_id', 'average': { $avg: '$scores.score' } } }, { '$sort': { 'average' : -1 } }, { '$limit': 1 } ] ) You will get the out fr...

Answer of MongoDB Quiz 9 is give below . db.movieDetails.find({"awards.oscars.award": "bestPicture"})

MongoDB Homework 2.5 Answer is given below in Image. I have executed query for video.movieDetails Collection and get exact answer which is given below.

MongoDB Homework 2.4 Answer is given below in Image. I have executed query for video.movieDetails Collection and get exact answer which is given below.

MongoDB .net development for user registration and login. I am going to explain step by step to learn registration and login in .net web application development. First of all download the handout from Homework 2.3 and extract it. Open it with visual studio 2013 or above version. Make sure DLL for MongoDB driver is added in your project otherwise download it with the help of Nugget Package manager. Now going to explain to write missing code in different CS file of project. First open User.CS file from your project .You may see there is marked with XXX sign . Replace your Code with below given. using System; using System.Collections.Generic; using System.Linq; using System.Web; using MongoDB.Bson.Serialization.Attributes; namespace M101DotNet.WebApp.Models { public class User { [BsonRepresentation(MongoDB.Bson.BsonType.ObjectId)] public string Id { get; set; } public string Name { get; set; } public string Email { ...

Download JSON data from homework 2.2 MongoDB of .Net development and use it to restore in MongoDB Database. Dataset contains four scores which each has two hundred students. First confirm that you have restored data correctly. Use below command to check your restored data. Data count should be 800. use students db.grades.count() Now , Lets find student who holds 101st across among grades. See the below query to find. db.grades.find().sort( { 'score' : -1 } ).skip( 100 ).limit( 1 ) Correct result is given below by executing the above query. { "_id" : ObjectId("50906d7fa3c412bb040eb709"), "student_id" : 100, "type" : "homework", "score" : 88.50425479139126 } Use below query for sorting of  data, Here I have use limit of 5 show it will show five record. db.grades.find( { }, { 'student_id' : 1, 'type' : 1, 'score' : 1, '_id' : 0 } ).sort( { 'student_id' : 1, ...

Answer of MongoDB Quiz 8 BulkWrite.

Answer of MongoDB Quiz 7 DeleteOne and DeleteMany.

Answer of MongoDB  Quiz 6 is given below. Below query make confuse to understand but it's very easy to understand .First line of query is  Limit(10) and skip(5) from 10 so that remaining will be 5. However another Limit(20) get the 20 show no any such value get from previous query .so that final result will be 20. col.Find(new BsonDocument()) .Limit(10) .Skip(5) .Limit(20);

Answer of Quiz 5 MongoDB Find with Filters class Person { [BsonElement("name")] public string Name; [BsonElement("age")] public int Age; } var col = db.GetCollection<Person>("people"); var list = await col.Find(x => x.Name == "James" && x.Age <= 24).ToListAsync();

Below answer which not able to enumerate query result . Remaining all can enumerate query result from collection of MongoDB data. Below three given method you may use to enumerate result by using C# in .Net applications. 1. ForEachAsync 2. ToListAsync 3. ToCursorAsync

This is Quiz so i have not added proper code here . Here i have just call a collection "People" to add some data. Below you may check exact answer of this question. var people = db.GetCollection<BsonDocument>("people"); var person = new BsonDocument { { "name", "Craig Wilson" }, {"company", "MongoDB" } }; await people.InsertOneAsync(person); person.Remove("_id"); await people.InsertOneAsync(person);

Answer of .Net driver document representation is given below. You may check from below attached image of Quiz 2 answer of week 2.

Which assembly contains MongoDb Client Class ? 1. MongoDB.Client 2. MongoDB.Driver.Core 3. MongoDB.BSON 4. MongoDB.Driver Answer is  :  4. MongoDB.Driver How to install MongoDB Driver in .net applications? First create a project which you may required. Select reference  in your project and select Nugget Package manager.This will open new window to install any package which you requre. Search Mongo Driver in search box . select MongoDB Driver and install it.You may see in below figure.

Download JSON data from homework 2.1 MongoDB of .Net development and use it to restore in MongoDB Database. Command is use to restore JSON data is below. mongoimport --drop -d students -c grades grades.json Data should be 800 inside collection which was restore .Check this by using following command. use students db.grades.count() Use below command to find exact answer. db.grades.aggregate({'$group':{'_id':'$student_id', 'average':{$avg:'$score'}}}, {'$sort':{'average':-1}}, {'$limit':1})

Answer of Homework 1.3 MongoDB for .Net development is  :  -1030 Download project from course of .net homework 1.3 and open it into your visual studio.It will display the answer which you required.

Answer of MongoDB homework 1.2 for .Net course of MongoDB. Valid JSON documents are given below in image

MongoDB homework 1.1 for .Net course of MongoDB Course. First download MongoDB from mongodb website and install it on your computer. and download homework hangout hw1.1 and uncompressed it . use the command to restore file in your mongdb mongorestore dump Use the command to find your answer. db.hw1.findone() Answer of  MongoDB homework 1.1 is  :   42

MongoDB is a document database.when we do  query with mongodb and data stored in MongoDB we need to use JSON or javascript object Notation. example of JSON Data which can insert in MongoDB. 1. Example :- { "title" : "Star Wars", "quotes" : [ "Use the Force", "These are not the droids you are looking for" ], "director" : "George Lucas" } { "a" : 1, "b" : { "b" : 1, "c" : "foo", "d" : "bar", "e" : [1, 2, 4] } } and it can also be blank JSON data which is { }.