User1120430333 posted
I don't know how to say: It feels like I'm losing control over database operations... as described above with Webforms I was used to writing my SQL queries myself. Now these thinks are abstracted, which confuses me a little bit. The last days I'm
used to search about "use MVC without entity framework". But the overall recommendation is to use the entity framework... at the moment I cannot imagine that I can do everything without using my own SQL queries.
There is nothing saying that you have to use the ADO.NET Entity Framework if you don't want to do so in an ASP.NET MVC project. You can still use ADO.NET with database command object, parmterized in-line T-SQL or parametrized Stored Procedures in doing
CRUD operations with a database.
You can also use a micro ORM like Dapper where you can still writer your T-SQL yourself or use a sproc.
https://www.infoworld.com/article/3025784/how-to-work-with-dapper-in-c.html
To me, a lot of developers don't understand the purpose of using a UI design pattern such as MVC.
https://www.codeproject.com/Articles/228214/Understanding-Basics-of-UI-Design-Pattern-MVC-MVP
The 3 UI design patterns can actually be used with Windows desktop or ASP.NET form based solutions if one choose to implement one of UI design pattern, becuase they are just UI design patterns. However, ASP.NET MVC has libraries that supplement its implementation
of the MVC pattern.
https://www.codeproject.com/Articles/383153/The-Model-View-Controller-MVC-Pattern-with-Csharp
Some of the JavaScript plugins use the MVC pattern as well, like AngularJs and others.
You should understand SoC in ASP.NET MVC.
https://www.c-sharpcorner.com/UploadFile/56fb14/understanding-separation-of-concern-and-Asp-Net-mvc/
You should understand about having fat Models, which means having classes in the Models folder that the controller uses keeping the controller skinny as skinny as possible.
https://docs.microsoft.com/en-us/aspnet/mvc/overview/older-versions-1/overview/understanding-models-views-and-controllers-cs
A lot of ASP.NET developers fall into the viewbag rabbit hole. It's not called Viewbag View Controller. It's called Model View Controller. :)
https://tech.trailmax.info/2013/12/asp-net-mvc-viewbag-is-bad/
You should understand how to use the viewmodel.
https://www.c-sharpcorner.com/article/managing-data-with-viewmodel-in-asp-net-mvc/
You can also look into the Layered architectural style or even n-tier and not have everything in the ASP.NET MVC project like so many developers do
https://docs.microsoft.com/en-us/previous-versions/msp-n-p/ee658117(v=pandp.10)
If you're using dataset and datatable, then you might want to use a collection using the DTO pattern for a collection of DTO(s) or a single DTO being used in doing CRUD with the low-level database technology, sending the DTO through the layers. If you use
the DTO pattern, the make a classlib project and put the DTO(s) in the classlib project. All projects needing to know about the DTO(s) will have reference to the classlib project and know what the DTO(s) are about..
https://dzone.com/articles/reasons-move-datatables
https://www.codeproject.com/articles/1050468/data-transfer-object-design-pattern-in-csharp
You should try to implement the 'new is glue' principle.
https://ardalis.com/new-is-glue
And how you implement the 'the new is glue is by implementing a Interface that allows loose coupling.
https://www.c-sharpcorner.com/blogs/understanding-interfaces-via-loose-coupling-and-tight-coupling
By using an Interface for loose coupling, it allows the implantations of an IoC and dependency injection, like using Unity, Autofac Winsdor Castlel and many other IoC(s).
https://www.c-sharpcorner.com/UploadFile/cda5ba/dependency-injection-di-and-inversion-of-control-ioc/
An example ASP.NET Core MVC controller that is using DI via an IoC, which is being used in all the classlib projects, the layers. And if you're going ASP.NET MVC , then go directly to ASP.NET Core MVC and don't look back.
using System;
using System.Linq;
using Microsoft.AspNetCore.Authorization;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.ModelBinding;
using ProgMgmntCore2UserIdentity.Models;
namespace ProgMgmntCore2UserIdentity.Controllers
{
public class TaskController : Controller
{
private readonly ITaskModel _taskModel;
private readonly IProjectModel _projectModel;
private readonly IModelHelper _modelHelper;
public TaskController(ITaskModel taskModel, IProjectModel projectModel, IModelHelper modelHelper)
{
_taskModel = taskModel;
_projectModel = projectModel;
_modelHelper = modelHelper;
}
// GET: Task
[Authorize]
public ActionResult Index(int id)
{
var project = _projectModel.GetProjectById(id);
TempData["ProjectId"] = id;
TempData["Title"] = project.ProjectName;
return View(_taskModel.GetTasksByProjectId(id));
}
[Authorize]
public ActionResult Details(int id = 0)
{
return id == 0 ? null : View(_taskModel.Edit(id));
}
[Authorize]
public ActionResult Create()
{
return View(_taskModel.Create());
}
[Authorize]
[HttpPost]
public ActionResult Create(TaskViewModels.TaskCreate task, string submit)
{
if (submit == "Cancel") return RedirectToAction("Index", new { id = (int)TempData["ProjectId"]});
ValidateddlStatuses();
ValidateddlDurations();
ValidateddlResources();
task.Status = (Request.Form["ddlStatusTypes"]);
task.TaskDuration = (Request.Form["ddlDurations"]);
task.ResourceId = (Request.Form["ddlResources"]);
if (!ModelState.IsValid) return View((TaskViewModels.TaskCreate)_taskModel.PopulateDropDownLists(task, "Create"));
_taskModel.Create(task, (int)TempData["ProjectId"]);
return RedirectToAction("Index", new { id = (int)TempData["ProjectId"] });
}
[Authorize]
public ActionResult Edit(int id = 0)
{
return id == 0 ? null : View(_taskModel.Edit(id));
}
[Authorize]
[HttpPost]
public ActionResult Edit(TaskViewModels.TaskEdit task, string submit)
{
if (submit == "Cancel") return RedirectToAction("Index", new { id = (int)TempData["ProjectId"]});
if (ModelState.IsValid && _modelHelper.IsEndDateLessThanStartDate(task, "Task"))
{
ModelState.AddModelError(String.Empty, "End Date cannot be less than Start Date.");
}
if (!ModelState.IsValid) return View( (TaskViewModels.TaskEdit)_taskModel.PopulateDropDownLists(task, "Edit"));
var thetask = new TaskViewModels.TaskEdit();
thetask = task;
thetask.ProjectId = (int) TempData["ProjectId"];
_taskModel.Edit(thetask);
return RedirectToAction("Index", new { id = (int)TempData["ProjectId"]});
}
public ActionResult Delete(int id = 0)
{
if (id > 0) _taskModel.Delete(id);
return RedirectToAction("Index", new { id = (int)TempData["ProjectId"] });
}
public ActionResult Cancel()
{
var id = TempData["ProjectId"];
return RedirectToAction("Index", "Home");
}
public ActionResult UploadFile(int id)
{
return RedirectToAction("Index", "Upload", new { id = id, type = "TM" });
}
private void ValidateddlStatuses()
{
if (Request.Form["ddlStatusTypes"] == string.Empty)
return;
foreach (var key in ModelState.Keys.ToList().Where(key => ModelState.ContainsKey(key)))
{
if (key != "Status") continue;
ModelState[key].Errors.Clear();
ModelState[key].ValidationState = ModelValidationState.Valid;
}
}
private void ValidateddlDurations()
{
if (Request.Form["ddlDurations"] == string.Empty)
return;
foreach (var key in ModelState.Keys.ToList().Where(key => ModelState.ContainsKey(key)))
{
if (key != "TaskDuration") continue;
ModelState[key].Errors.Clear();
ModelState[key].ValidationState = ModelValidationState.Valid;
}
}
private void ValidateddlResources()
{
if (Request.Form["ddlResources"] == string.Empty)
return;
foreach (var key in ModelState.Keys.ToList().Where(key => ModelState.ContainsKey(key)))
{
if (key != "ResourceId") continue;
ModelState[key].Errors.Clear();
ModelState[key].ValidationState = ModelValidationState.Valid;
}
}
}
}
