I use Dapper and N-tier architecture in my ASP.NET Core 8.0 project. My project works with SignalR, but when I add SqlDependency, I get an error Unable to connect to web server https Hub side: public class AppHub : Hub…
When attempting to store date and time in a SQL Server table, the time does not correspond with the local time zone. What should I do to rectify the time? Here is the code I've used. public class Stage1Model {…
I have aplication by .Net Core API 7 and my app will save user info by session like this code when they login public int _UserId { get { if (HttpContext.Session.GetInt32("UserId") == null) { HttpContext.Session.SetInt32("UserId", 0); } return (int)HttpContext.Session.GetInt32("UserId"); }…
I am trying to create POST, PATCH, and PUT methods in a .NET Core Web API for a database table that contains a foreign key. I am unsure if the problem lies in my method or in the way I…
I have an ASP.NET Core 6 Web API (User.API) that I'm trying to run in a Docker container, alongside a separate SQL Server container. My goal is to deploy these containers on a friend's machine without requiring them to install…
[HttpPost("Login")] public async Task<IActionResult> Login([FromBody] SigninViewModel formData) { MemberCredential membercredential = await db.MemberCredential.FirstOrDefaultAsync(t => t.MemberAccount.Equals(formData.memberAccount)); if (membercredential == null) { var test = new { success = false, message = "無此帳號，請重新輸入。" }; Console.WriteLine(test); return BadRequest(new { success = false, message…
I made a strongly typed id to prevent ids from entity A from being mixed with entity B, like so: public record struct Id<TEntity>(int Value); I also created and registered an IModelBinder and a IModelBinderProvider, so that I can have…
I have an API that has a simple "sign-in" link on a plain, hand-written HTML page (no razor pages, no asp pages, nothing). After I sign in, the cookie is stored so I can use the swagger UI to make…
Current Behavior - From our service-A, we are calling service-B. We are currently using client_credentials as a way to generate access_token for service-B(as shown below). Service-B is validating token generated at their end and everything is working fine. Expected behavior…
I want to send a 4 digit(numeric) OTP using Send Grid With HTML Template in asp.net core7 WebAPI. I am able to send a mail without template.