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

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;           ...

Get user groups

 string[] scopes = new string[] { "https://graph.microsoft.com/.default" };             string clientId = "";             string tenantId = "";             string secret = "";                        var options = new TokenCredentialOptions             {                 AuthorityHost = AzureAuthorityHosts.AzurePublicCloud             };             // https://learn.microsoft.com/dotnet/api/azure.identity.clientsecretcredential             try             {                 var clientSecretCredential = new ClientSecretCredential(                        ...