{"id":16,"date":"2023-05-04T07:08:10","date_gmt":"2023-05-04T06:08:10","guid":{"rendered":"https:\/\/ishooscode.com\/?p=16"},"modified":"2023-06-01T09:12:42","modified_gmt":"2023-06-01T08:12:42","slug":"implementing-repository-with-aspnetcore-mvc","status":"publish","type":"post","link":"https:\/\/ishooscode.com\/index.php\/2023\/05\/04\/implementing-repository-with-aspnetcore-mvc\/","title":{"rendered":"Implementing Repository with AspNetCore MVC"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

In this blog I will create an application using .net Core MVC and Entity framework core implementing Repository pattern and Dependency Injection.
I will make the application loosely coupled as much as possible. Data access layer and UI will be completely independent of each other.<\/p>\n\n\n\n

Prerequisite<\/strong><\/p>\n\n\n\n

Prior knowledge of MVC and Entity framework<\/p>\n\n\n\n

Let\u2019s begin<\/p>\n\n\n\n

Project Creation<\/strong><\/p>\n\n\n\n

I am using visual studio 2019 community edition.
Open your IDE and create .net core MVC project<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Select Asp.Net Core Web Application and press next<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Name your solution and create<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Project is created<\/p>\n\n\n\n

The solution will have Controller, Model, View folder and one new wwwroot folder and few more files named appsetting.json, Startup.cs, Program.cs<\/p>\n\n\n\n

Let\u2019s understand what these files are?<\/p>\n\n\n\n

Appsetting.json file is your web.config file
Program.cs file is same as in your console application and is called once for the entire application life cycle
Startup.cs is used for configuring your .net core application<\/p>\n\n\n\n

Let us create a small module of adding product in Ecommerce website<\/p>\n\n\n\n

Model<\/strong><\/p>\n\n\n\n

First create a Product model in, for that we will create a new .net core class library project in same solution<\/p>\n\n\n\n

namespace ECommerce.Entity\n{\n    [Table(\"Product\")]\n    public class Product\n    {\n        [Key]\n        public string ProductId { get; set;  }\n\n        [Required]\n        [MaxLength(50)]\n        public string ProductName { get; set; }\n\n        [MaxLength(300)]\n        public string ProductDescription { get; set; }\n\n        [Required]\n        [DisplayName(\"Category\")]\n        public string CategoryId { get; set; }\n\n        [Required]\n        public double QuantityPerUnit { get; set; }\n\n        [Required]\n        public double UnitPrice { get; set; }\n\n        [Required]\n        public double MSRP { get; set; }\n\n        public double AvailableSize { get; set; }\n\n        public string AvailableColor { get; set; }\n\n        public double Discount { get; set; }\n        [Required]\n        public double UnitWeight { get; set; }\n\n        [Required]\n        public double UnitsInStock { get; set; }\n\n        public double UnitsOnOrder { get; set; }\n\n        public double ProductAvailability { get; set; }\n\n        public string Picture { get; set; }\n\n        public string Note { get; set; }\n    }\n}<\/code><\/pre>\n\n\n\n
This model will be used to save data and bind view and controller.<\/p>\n\n\n\n
Entity framework core Context<\/strong><\/p>\n\n\n\n
Next step is to create Entity framework core context. For that we create a new .net core class library project and install a nugget package in it.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Create a ECommerceContext class<\/p>\n\n\n\n
public class ECommerceContext : DbContext\n    {\n\n        public ECommerceContext(DbContextOptions<ECommerceContext> options) : base(options)\n        {\n\n        }\n\n        public DbSet<Product> Products { get; set; }\n    }<\/code><\/pre>\n\n\n\n
Repository<\/strong><\/p>\n\n\n\n
Now let\u2019s create a new .net core class library project named Ecommerce.IRepositories<\/p>\n\n\n\n
And create an interface in the project. This project will only contain Interfaces<\/p>\n\n\n\n
public interface IProductRepository\n{\n    IList<Product> GetProducts();\n    Product GetProduct(string productId);\n    void Add(Product product);\n    Product Update(Product product);\n    void Delete(Product product);\n}<\/code><\/pre>\n\n\n\n
Interfaces plays key roles in making application loosely coupled and more injectable more<\/p>\n\n\n\n
To implement this interface we\u2019ll create another .net core class library project for repository<\/p>\n\n\n\n
Name Ecommerce.Repositories and create a class<\/p>\n\n\n\n
public class ProductRepository : IProductRepository\n{\n        private readonly ECommerceContext productContext;\n\n        public ProductRepository(ECommerceContext context)\n        {\n            productContext = context;\n        }\n\n        public void Add(Product product)\n        {\n            product.ProductId = Guid.NewGuid().ToString();\n            productContext.Add(product);\n            productContext.SaveChanges();\n        }\n\n        public void Delete(Product product)\n        {\n            productContext.Products.Remove(product);\n            productContext.SaveChanges();\n        }\n\n        public IList<Product> GetProducts()\n        {\n            return productContext.Products.ToList();\n        }\n\n        public Product GetProduct(string productId)\n        {\n            return productContext.Products.FirstOrDefault(x=> x.ProductId == productId);\n        }\n\n        public Product Update(Product productChanges)\n        {\n            var product = productContext.Products.Attach(productChanges);\n            product.State = Microsoft.EntityFrameworkCore.EntityState.Modified;\n            productContext.SaveChanges();\n            return productChanges;\n        }\n    }<\/code><\/pre>\n\n\n\n
Now, we have created our context, our model and our repository.<\/p>\n\n\n\n
Application<\/strong><\/p>\n\n\n\n
It\u2019s time to create controller named ProductController.cs and inject all the dependency in it. To inject the dependencies we need to configure startup.cs file<\/p>\n\n\n\n
Add following code in ConfigureService method<\/p>\n\n\n\n
services.AddScoped<IProductRepository, ProductRepository>();\nservices.AddDbContextPool<ECommerceContext>(x => x.UseSqlServer(ConnectionString, b => b.MigrationsAssembly(\"ECommerce\")));<\/code><\/pre>\n\n\n\n
controller will look like below code<\/p>\n\n\n\n
IProductRepository productRepo = null;\n\npublic ProductController(IProductRepository prodRepo)\n{\n    productRepo = prodRepo;\n}<\/code><\/pre>\n\n\n\n
As you can see we are using parameterized constructor of controller to inject the dependency.<\/p>\n\n\n\n
.net core there is a build in support for dependency injection<\/p>\n\n\n\n
services.AddScoped<IProductRepository, ProductRepository>();<\/code><\/pre>\n\n\n\n
Above line is used to inject any dependency in controller<\/p>\n\n\n\n
Below method is used to save Product detail in database<\/p>\n\n\n\n
public ActionResult SaveProduct(Product product)\n\n        {\n            int res = 3;\n            if (ModelState.IsValid)\n            {\n                if (string.IsNullOrEmpty(product.ProductId))\n                {\n                    productRepo.Add(product);\n                }\n                else {\n                    product = productRepo.Update(product);\n                }\n                res = 1;\n            }\n            else {\n            }\n            return View(\"Create\");\n        }<\/code><\/pre>\n\n\n\n
View to controller binding is same as it was in MVC application and I understand you guys are better at that so not going through with it<\/p>\n\n\n\n
Notes<\/strong><\/p>\n\n\n\n
If you look at the Repository class, I have injected context class in its constructor.<\/p>\n\n\n\n
Summary<\/strong><\/p>\n\n\n\n
This is how you create a .net core MVC application with Repository and dependency injection which is loosely coupled and easily configurable<\/p>\n\n\n\n
I am open to all kind of discussion. Feel free to comment and suggest anything<\/p>\n\n\n\n
For more details please visit <\/a><\/p>\n\n\n\n
Thank you.<\/p>\n","protected":false},"excerpt":{"rendered":"
In this blog I will create an application using .net Core MVC and Entity framework core implementing Repository pattern and Dependency Injection.I will make the application loosely coupled as much as possible. Data access layer and UI will be completely independent of each other. Prerequisite Prior knowledge of MVC and Entity framework Let\u2019s begin Project […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"wpai_generated_summary":"","wpai_tts_display_audio":true,"footnotes":""},"categories":[23,22],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-aspdotnet","category-c-sharp"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t