Skip to main content

MongoDB

Download MongoDB from https://www.mongodb.com/what-is-mongodb 

Install MongoDb nuget package: MongoDB.Driver (Author: rstam.craigwilson)


Service 

______________________________________________________________________
public interface IMongoService
    {
         Employee CreateEmployee(Employee employee);
        void Delete(string id);
        Employee GetEmployeeById(string id);
        List<Employee> GetEmployees();
        Employee Update(Employee employee);
    }

public class MongoService : IMongoService
    {
        IMongoCollection<Employee> _mongoCollection;
        public MongoService(IOptions<EmpDatabaseSettings> options)
        {
            Options = options;
            var client = new MongoClient(options.Value.ConnectionString);
            var database = client.GetDatabase(options.Value.DatabaseName);

            _mongoCollection = database.GetCollection<Employee>(options.Value.EmpCollectionName);
        }

        public IOptions<EmpDatabaseSettings> Options { get; }

        public List<Employee> GetEmployees()
        {
            return _mongoCollection.Find(i => true).ToList();
        }

        public Employee GetEmployeeById(string id)
        {
            return _mongoCollection.Find(i => i.Id.Equals(id)).FirstOrDefault();
        }

        public Employee CreateEmployee(Employee employee)
        {
            _mongoCollection.InsertOne(employee);
            return employee;
        }

        public Employee Update(Employee employee)
        {
            _mongoCollection.ReplaceOne(i => i.Id.Equals(employee.Id), employee);
            return employee;
        }

        public void Delete(string id)
        {
            _mongoCollection.DeleteOne(i => i.Id.Equals(id));
        }

__________________________________________________________________

Controller


[Route("api/Employee")]
    [ApiController]
    public class ValuesController : ControllerBase
    {
        public IMongoService MongoService { get; }

        public ValuesController(IMongoService mongoService)
        {
            MongoService = mongoService;
        }

        [HttpGet()]
        public IActionResult GetAllEmployees()
        {
            try
            {
                return Ok(this.MongoService.GetEmployees());
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }

        }

        [HttpGet("{id}")]
        public IActionResult GetEmployeeById(string id)
        {
            try
            {
                return Ok(this.MongoService.GetEmployeeById(id));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }

        [HttpPost()]
        public IActionResult CreateEmployee([FromBody]Employee employee)
        {
            try
            {
                return Ok(this.MongoService.CreateEmployee(employee));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }

        [HttpPut()]
        public IActionResult UpdateEmployee([FromBody]Employee employee)
        {
            try
            {
                return Ok(this.MongoService.Update(employee));
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }

        [HttpDelete("{id}")]
        public IActionResult DeleteEmployee(string id)
        {
            try
            {
                this.MongoService.Delete(id);
                return Ok();
            }
            catch (Exception ex)
            {
                return BadRequest(ex.Message);
            }
        }


    }
__________________________________________________________________

classes

 public class Employee
    {
        [BsonId]
        [BsonRepresentation(BsonType.ObjectId)]
        public string Id { get; set; }
        public string Name { get; set; }
        public int Age { get; set; }
        public Details Details { get; set; }
    }

    public class Details
    {
        public string City { get; set; }

        public string Address { get; set; }
    }

___________________________________________________________

Appsettings.json

 "EmpDatabaseSettings": {
    "EmpCollectionName": "Employee",
    "ConnectionString": "mongodb://localhost:27017",
    "DatabaseName": "EmployeeDB"
  },


  public class EmpDatabaseSettings
    {
        public string EmpCollectionName { get; set; }
        public string ConnectionString { get; set; }
        public string DatabaseName { get; set; }
    }

____________________________________________________________________

Strartup.cs 

Inside ConfigureServices (Register these dependencies)

 services.Configure<EmpDatabaseSettings>(this.Configuration.GetSection(nameof(EmpDatabaseSettings)));
           
 services.AddTransient<IMongoService, MongoService>();

Comments

Popular posts from this blog

Az-500 NSG and ASG

Application security groups Application security groups enable you to configure network security as a natural extension of an application's structure, allowing you to group virtual machines and define network security policies based on those groups. You can reuse your security policy at scale without manual maintenance of explicit IP addresses. The platform handles the complexity of explicit IP addresses and multiple rule sets, allowing you to focus on your business logic. To better understand application security groups, consider the following example: In the previous picture,  NIC1  and  NIC2  are members of the  AsgWeb  application security group.  NIC3  is a member of the  AsgLogic  application security group.  NIC4  is a member of the  AsgDb  application security group. Though each network interface in this example is a member of only one network security group, a network interface can be a member of multiple app...

App Role assignment to service principal --

 Using Ms Graph Rest API's Permissions One of the following permissions is required to call this API. To learn more, including how to choose permissions, see  Permissions . Permission type Permissions (from least to most privileged) Delegated (work or school account) AppRoleAssignment.ReadWrite.All and Application.Read.All, AppRoleAssignment.ReadWrite.All and Directory.Read.All, Application.ReadWrite.All, Directory.ReadWrite.All Delegated (personal Microsoft account) Not supported. Application AppRoleAssignment.ReadWrite.All and Application.Read.All, AppRoleAssignment.ReadWrite.All and Directory.Read.All, Application.ReadWrite.All, Directory.ReadWrite.All Create 2 app registrations. App role owner will contain the app role that will be assigned to a service principal. The  reader role in approleowner will be added to the approlesubscriber Setup postman to use the Oauth auth flow to get a token for MS Graph. ClientId:   Application (client) ID for approlesubscrib...

ASp.net core 3.1 identity

It is just an extension to cookie authentication. We get a UI, Tables, helper classes, two factor authentication etc. Even EF and its database constructs. So instead of writing code for all of this we can just use these in built features. Extending Default Identity Classes Add a class that inherits from    public class AppUser : IdentityUser     {         public string Behavior { get; set; }     } Also change the user type in login partial.cs under shared folder Then add migrations and update db using migrations. We can customize further.  services.AddDefaultIdentity<AppUser>(options =>              {                 options.SignIn.RequireConfirmedAccount = true;                 options.Password.RequireDigit = false;           ...