Asp.Net with MySql

Question

I'm developing an API for my android app.

I'm using the API for accessing MySql from android via Asp.Net.

Like this,

[Route("api/v1/getMethodExample")]
[HttpGet]
public int GetMethodExample(string parametre)
{   
    mySqlConnection = new MySqlConnection("");
    mySqlConnection.Open();
    ...
    //Do something with mysql
    int value = mySqlConnection.get("myTable","4");//in example 
    mySqlConnection.Close();
    return value;
}

In short, for every web API call, I'm connecting MySql, getting data and closing MySql.

Is this right way?

generally, i don't see anything wrong with it and to my knowledge e.g. flask app will do the same. you just should not connect more than once per your API call, if you need to query db multiple times to return one result. if you have many thousands calls per second, you can think about something else. — grepe
– grepe, Commented Oct 28, 2016 at 12:37
you should use a using statement for proper disposal. This q/a should help you — Mark C.
– Mark C., Commented Oct 28, 2016 at 12:47
Sort of. It is correct to open and close new connections. ADO.Net providers using something called connection pooling to keep this efficient. However, the pattern you posted to demonstrate this has some deficiencies (namely the "using" issue mentioned in other comments). — Joel Coehoorn
– Joel Coehoorn, Commented Oct 28, 2016 at 13:52

struggleendlessly · Accepted Answer · 2016-10-28 12:38:00Z

-2

Yes. It's default behavior. In other way you will block context for other requests

answered Oct 28, 2016 at 12:38

struggleendlessly

1182 gold badges2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark C. Over a year ago

No mention of a using statement or anything? Can you elaborate on your answer as to why OPs question is the best approach?

Collectives™ on Stack Overflow

Asp.Net with MySql

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related