DEV Community: FaithInErrorsZORO

Using sessions in asp.net anyone have any insight?

FaithInErrorsZORO — Fri, 17 Apr 2026 03:39:10 +0000

here is how i set it up in program.cs :

builder.Services.AddDistributedMemoryCache();
builder.Services.AddSession(options =>
{
options.IdleTimeout = TimeSpan.FromMinutes(10); // [cite: 16]
options.Cookie.HttpOnly = true;
options.Cookie.IsEssential = true;
});

var app = builder.Build();

[cite_start]// 2. Add Session Middleware (between Routing and Endpoints) [cite: 17]
app.UseRouting();
app.UseSession();
app.UseAuthorization();

here is how i reference the session

[[HttpPost]
public IActionResult Index(string lastName)
{
var player = _context.Players.FirstOrDefault(p => p.LastName == lastName);

if (player == null)
{
    ViewBag.Message = "No player found with that last name.";
    return View();
}

// Store IDs in Session for later use
HttpContext.Session.SetString("playerId", player.PlayerId.ToString());
HttpContext.Session.SetInt32("coachId", player.CoachId ?? 0);
HttpContext.Session.SetInt32("teamId", player.TeamId ?? 0);

return View("Display", player);

}

action to show the stats:

public IActionResult ShowStats()
{
var pId = HttpContext.Session.GetString("playerId");

var playerWithStats = _context.Players
    .Include(p => p.GameRecords)
        .ThenInclude(gr => gr.StatCategory)
    .FirstOrDefault(p => p.PlayerId.ToString() == pId);

return View(playerWithStats);

}

dif types :

public IActionResult ShowCoach()
{
var pId = HttpContext.Session.GetString("playerId");
var cId = HttpContext.Session.GetInt32("coachId");
var tId = HttpContext.Session.GetInt32("teamId");

var player = _context.Players.Find(int.Parse(pId));
var coach = _context.Coaches.Find(cId);
var team = _context.Teams.Find(tId);

// Join class/ViewModel to pass all three objects to the view
var viewModel = new PlayerCoachTeamViewModel { 
    Player = player, 
    Coach = coach, 
    Team = team 
};

return View(viewModel);

}

Making good/ proper line queries in c#?

FaithInErrorsZORO — Wed, 01 Apr 2026 15:49:20 +0000

Query ?:var customerOrdersQuery = (from c in db.Customers
join o in db.Orders on c.CustomerId equals o.CustomerId
select new
{
CustomerName = c.Name,
OrderDate = o.OrderDate
}).ToList();

Method:var customerOrdersMethod = db.Customers
.Join(
db.Orders, // 1. Table to join
c => c.CustomerId, // 2. Key from the first table (Customers)
o => o.CustomerId, // 3. Key from the second table (Orders)
(c, o) => new // 4. The data you want to select
{
CustomerName = c.Name,
OrderDate = o.OrderDate
}
).ToList();

And then to display : @model IEnumerable

@{
ViewData["Title"] = "Full Order Report";
}

<h2>Customer Order Report</h2>

<table>
    <thead>
        <tr>
            <th>Customer Name</th>
            <th>Product Purchased</th>
            <th>Date of Order</th>
        </tr>
    </thead>
    <tbody>
        @* Loop through the joined data stored in the ViewModels *@
        @foreach (var item in Model)
        {
            <tr>
                <td>@item.CustomerName</td>
                <td>@item.ProductName</td>
                <td>@Html.DisplayFor(modelItem =&gt; item.OrderDate)</td>
            </tr>
        }
    </tbody>
</table>

SQL triggers for blocking

FaithInErrorsZORO — Fri, 20 Mar 2026 12:58:26 +0000

AFTER INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON;

-- Look for the modified InvoiceId in the list of invoices exceeding the limit
IF (SELECT TOP 1 InvoiceId FROM Inserted) IN (
    SELECT InvoiceId
    FROM (
        SELECT IL.InvoiceId, COUNT(*) AS count
        FROM InvoiceLine IL
        JOIN Track T ON IL.TrackId = T.TrackId
        WHERE T.GenreId = 32 --  Genre
        GROUP BY IL.InvoiceId
    ) AS Summary
    WHERE count > 3
)
BEGIN
    RAISERROR ('Market Overload! Max 3 Anime items per invoice.', 16, 1);
    ROLLBACK TRANSACTION;
END

END;

Is this the best way to use middleware in a mvc asp.net app?

FaithInErrorsZORO — Fri, 13 Feb 2026 13:51:00 +0000

Here is program.cs:

var builder = WebApplication.CreateBuilder(args);

builder.Services.AddControllersWithViews();

var app = builder.Build();

app.UseStaticFiles();
app.UseRouting();

app.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");

app.Run();