I have a table that collects securities holdings data for Funds like below. How do I extract latest data for each FundName? EffectiveDate FundName SecurityName PercentageOfAssets 30/06/2022 Fund A xxx 33.33% 30/06/2022 Fund A yyy 33.33% 30/06/2022 Fund A zzz…
I am trying to connect my ASP.NET Core 6 application to SQL Server, but I get an error on the connection string. Does anyone have experience with .NET 6 that could help? This is my code in my class (book.cs).…
I have created a stored procedure in SQL Server which returns in json format ALTER PROCEDURE [dbo].[GetAllRoles] AS BEGIN SELECT * FROM dbo.roles FOR JSON PATH; END Output of this stored procedure: [ { "role_id": 101, "role_description": "Trainee" }, {…
I have migrated my existing SQL server database to MySQL server database using MySQL workbench Migration Wizard. Because these are two different database servers, I want to ensure there is no data loss along with stored procedures, triggers, and views,…
I am developing a light weight web app in ASP.NET with C# and I would like to store some data such as site analytics etc. Instead of using a SQL server database could I use a JSON file instead? So…
I do a project in ASP.NET Core 6.0 and try to connect a database. Program.cs: using ClanSS.Data; using ClanSS.Data.Repository; using Microsoft.AspNetCore.Hosting; using Microsoft.EntityFrameworkCore; var builder = WebApplication.CreateBuilder(args); builder.Services.AddControllersWithViews(); builder.Services.AddScoped<IRepository, Repository>(); builder.Services.AddDbContext<AppDbContext>(options => { options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")); }); var app = builder.Build(); if…
I already have a v16 running in Azure. Now, I'm trying to run a Keycloak 19 in Azure WebApp (with Azure SQL Server), but the container always stop with timeout. My dockerfile FROM quay.io/keycloak/keycloak:latest as builder ENV KC_HEALTH_ENABLED=true ENV KC_METRICS_ENABLED=true…
We are storing data corresponding to rates (ex: electricity price) in a SQL table, such as: Date Value 2022-08-25 01:00 12.3 2022-09-23 06:12 14.5 2022-10-18 05:34 9.8 The date interval between two rows is not regular. In this table, 12.3…
may be somebody know what the problem appears. I try to start api with db conteiners but always my Fluent Migrator failed with db connection I created the docker file: FROM mcr.microsoft.com/dotnet/sdk:6.0 AS build-env WORKDIR /src COPY *.sln "./" COPY…
Below are code snippets of what I currently use to import and export Excel files. However, is it possible to make this work through an Azure Web App which is serverless? C# File.WriteAllBytes(@"c:tempreport.xlsx", excel.GetAsByteArray()); SQL Server INSERT INTO Employee (FirstName,…