public List <string> GetDataDataBaseLists(DataBaseNameFilterServiceModel databaseFilterServiceModel) { try { if (databaseFilterServiceModel == null) { } string connectionString = string.Empty; List <string> dataBaseName = new List <string>(); if (!string.IsNullOrEmpty(databaseFilterServiceModel.UserName) || !string.IsNullOrEmpty(databaseFilterServiceModel.Password)) { connectionString = "server= " + databaseFilterServiceModel.ServerInstanceName + " ;uid=" + databaseFilterServiceModel.UserName + ";pwd=" + databaseFilterServiceModel.Password + ";"; } else { connectionString = "Data Source=" + databaseFilterServiceModel.ServerInstanceName + "; Integrated Security=True;"; } using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand("SELECT name from sys.databases", conn)) { using (IDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { dataBaseName.Add(dr[0].ToString()); } } } } return(dataBaseName); } catch (Exception ex) { throw; } }
public HttpResponseMessage GetDatabaseName(DataBaseNameFilterServiceModel databaseFilterServiceModel) { return(Request.CreateResponse(HttpStatusCode.OK, _dataBaseConnectionService.GetDataDataBaseLists(databaseFilterServiceModel))); }