C#

services.AddScoped<DbContext>(_ =>
{
    string connString = Properties.Settings.Default.ConnectionString;
    return new SqlDataContext(connString);
});

Richard Deeming wrote:

Are you using Dependency Injection? Ideally, the DbContext and repository classes should be registered as "scoped" dependencies. The context would be injected into the repository, and the repository would be injected into the controller.

Richard Deeming wrote:

f you need to manage the connection string differently,

Kevin Marois wrote:

It seems to me that the ConnectionString belongs in the Repository project.

Richard Deeming wrote:

The connection string shouldn't be hard-coded anywhere. It belongs in the configuration settings of the application - in this case, the web site.

private void FormMeasurement_Load(object sender, EventArgs e)
{
    listBoxMeasurement.Enabled = false;
    _ = LoadFormAsync();
}

private async Task LoadFormAsync()
{
    try
    {
        using (var connection = new MySqlConnection(connString))
        {
            await connection.OpenAsync();
            
            const string query = "select * from weather";
            using (var command = new MySqlCommand(query, connection))
            using (var reader = await command.ExecuteReaderAsync())
            {
                while (await reader.ReadAsync())
                {
                    listBoxMeasurement.Items.Add(string.Format("Temperature: {0}   Humidity: {1}   Date: {2}", 
                        reader.GetString("temp"), reader.GetString("hum"), reader.GetString("datecreated")));
                }
            }
        }
        
        listBoxMeasurement.Enabled = true;
    }
    catch (Exception ex)
    {
        MessageBox.Show("Database is not available for moment!\n" + ex.Message);
    }
}

int foo = 1;

int foo = new Student();

int x = 666;

string userName = " vineeth s";

<Variable Type> <Variable Name> <Optional initialization value>;

BillWoodruff wrote:

var mystudent = new Student();

Student student = new();

var students = new List<Student>
{
    new Student { ... },
    new Student { ... },
};

List<Student> students = new()
{
    new() { ... },
    new() { ... },
};