Skip to main content
This guide covers the configuration of TechCore Mini ERP, including database connection strings and application settings.

​
Configuration Files

TechCore uses the standard ASP.NET Core configuration system with these files:
  • appsettings.json - Base configuration for all environments
  • appsettings.Development.json - Development-specific overrides

​
Database Configuration

TechCore uses SQL Server with Entity Framework Core 10.0.3. The connection string is configured in the ConnectionStrings section.

​
Default Connection String

The default configuration in appsettings.json: 
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=.\\;Database=TechCore;Trusted_Connection=True;TrustServerCertificate=True;"
  }
}
This connection string:
  • Connects to the local SQL Server instance (Data Source=.\\)
  • Uses the database named TechCore
  • Uses Windows Authentication (Trusted_Connection=True)
  • Trusts the server certificate (TrustServerCertificate=True)

​
Customizing the Connection String

1

For local SQL Server instance

If using a named SQL Server instance:
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=.\\SQLEXPRESS;Database=TechCore;Trusted_Connection=True;TrustServerCertificate=True;"
  }
}
2

For SQL Server with authentication

If using SQL Server authentication instead of Windows Authentication:
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=localhost;Database=TechCore;User Id=your_username;Password=your_password;TrustServerCertificate=True;"
  }
}
Never commit credentials to source control. Use user secrets or environment variables for sensitive data.
3

For remote SQL Server

To connect to a remote SQL Server:
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=server-address,1433;Database=TechCore;User Id=your_username;Password=your_password;Encrypt=True;TrustServerCertificate=False;"
  }
}

​
Using User Secrets (Development)

For local development, use .NET User Secrets to store sensitive configuration:
1

Initialize user secrets

dotnet user-secrets init
2

Set connection string

dotnet user-secrets set "ConnectionStrings:DefaultConnection" "Data Source=.\\SQLEXPRESS;Database=TechCore;User Id=myuser;Password=mypassword;TrustServerCertificate=True;"
3

List secrets

Verify your secrets:
dotnet user-secrets list

​
Application Settings

​
Logging Configuration

The default logging configuration: 
{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  }
}
  • Default: Information - Shows informational messages and above
  • Microsoft.AspNetCore: Warning - Reduces noise from ASP.NET Core framework logs

​
Allowed Hosts

{
  "AllowedHosts": "*"
}
In production, restrict this to specific domains: 
{
  "AllowedHosts": "yourdomain.com;www.yourdomain.com"
}

​
Environment-Specific Configuration

​
Development Environment

The appsettings.Development.json file is automatically loaded when running in Development mode. It overrides settings from the base appsettings.json. Set the environment variable: 
$env:ASPNETCORE_ENVIRONMENT="Development"

​
Production Environment

For production, set: 
$env:ASPNETCORE_ENVIRONMENT="Production"

​
Database Context Configuration

The database context is configured in Program.cs:
Program.cs:12-15
builder.Services.AddDbContext<TechCoreContext>(options => { 
    var connectionString = builder.Configuration.GetConnectionString("DefaultConnection");
    options.UseSqlServer(connectionString);
});
This configuration:
  • Registers TechCoreContext as a scoped service
  • Reads the connection string from configuration
  • Configures Entity Framework Core to use SQL Server

​
Running Migrations

After configuring your database connection, apply migrations: 
dotnet ef database update
This creates the TechCore database and all required tables.

​
Next Steps

Build docs developers (and LLMs) love

Get started for freeTalk to us