I have a .NET project that runs on several machines and uses SQL server
On one development machine that doesnt have an SQL server, i want to use an mdf file as an SQL server. I ping the SQL 'server' approx every second. I see that the opening of the connection might last for several seconds.
is it normal?
should i keep the connection open?
what are the best practices to do it?