maily89 / fbdm

Automatically exported from code.google.com/p/fbdm
0 stars 0 forks source link

test DB connection. #133

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
Incase program cannot connect to database, should check this and redirect to DB 
error page

suggest: add this to AccessManager function?

try
            {
                var FBDModel = new FBDEntities();

                FBDModel.Connection.Open();

                if (FBDModel.Connection.State != System.Data.ConnectionState.Open) throw new Exception();

                if(FBDModel.Connection.State!= System.Data.ConnectionState.Closed)
                {
                    FBDModel.Connection.Close();
                }
            }
            catch
            {
                //redirect to Error page here
            }

Original issue reported on code.google.com by maily...@gmail.com on 15 Apr 2011 at 3:28

GoogleCodeExporter commented 9 years ago

Original comment by longnhi....@gmail.com on 30 Apr 2011 at 3:33