Streaming Sql Server Opening Connection  
Author Message
FlyinBrian





PostPosted: .NET Framework Data Access and Storage, Streaming Sql Server Opening Connection Top

So im trying to figure out a way to streamline establishing a connection with a sql db. In other words I don't want my app to 'hang' while its attempting to connect because the db might not be online or the users computer is not properly connected. Either way I wouldn't want the app to hang. Any ideas


.NET Development19  
 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Streaming Sql Server Opening Connection Top

doing any form of connection will result in a delay, especially databases since they are expensive to work with. you could spin up another thread to do your database work, which will prevent the main thread (UI) from being unresponsive.



 
 
FlyinBrian





PostPosted: .NET Framework Data Access and Storage, Streaming Sql Server Opening Connection Top

Hmm i was thinkin bout that, thanks