connection string های دیتابیس هایی که Blazor از آنها پشتیبانی می کند

1
2
3
4
5
6

SQL Server:
{
  "ConnectionStrings": {
    "DefaultConnection": "Server=myServerAddress;Database=myDatabase;User Id=myUsername;Password=myPassword;"
  }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

MySQL:
{
  "ConnectionStrings": {
    "DefaultConnection": "server=myServerAddress;port=3306;database=myDatabase;user=myUsername;password=myPassword;"
  }
}
PostgreSQL:
{
  "ConnectionStrings": {
    "DefaultConnection": "Server=myServerAddress;Port=5432;Database=myDatabase;User Id=myUsername;Password=myPassword;"
  }
}
SQLite:
{
  "ConnectionStrings": {
    "DefaultConnection": "Data Source=myDatabase.db;"
  }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

Oracle:
{
  "ConnectionStrings": {
    "OracleConnection": "Data Source=your_database_server;User ID=your_username;Password=your_password;"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  }
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21

using Microsoft.Extensions.Configuration;

using Oracle.ManagedDataAccess.Client;
 

public class Startup
{
    private readonly IConfiguration _configuration;
 
    public Startup(IConfiguration configuration)
    {
        _configuration = configuration;
    }
 
    public void ConfigureServices(IServiceCollection services)
    {
        var connectionString = _configuration.GetConnectionString("OracleConnection");
        services.AddSingleton(new OracleConnection(connectionString));
        // ...
    }
 
    // ...
}