Connection Open & Connection Close, Dispose

Question

Hi,

I saw this great article from one of the MVP

https://gavilan.blog/2019/05/10/asp-net-core-using-stored-procedures-with-ado-net/ .

I only saw the Connection Open. But no Connection Close & Dispose. It is in ASP.NET Core, we don't nee anymore the Connection Close & Dispose? We can assume that ASP.NET is intelligent enough

If we need to adding Connection Close & Dispose, please tell me at " where ? "

Need technical explanation

Answer 1

Asp.net does not know about your connections and your code shoukd dispose. Just use a using statement, like the sample code.