Get all databases from SQL Server programatically using c#

 public class DatabasesDataContract
    {
        public int DBId { get; set; }
        public string DatabaseName { get; set; }
    }

public class ConnStringDataContract
    {
        [DataMember]
        public string Server { get; set; }
        [DataMember]
        public string InitialCatalog { get; set; }
        [DataMember]
        public string UserName { get; set; }
        [DataMember]
        public string Password{ get; set; }
    }

public List<DatabasesDataContract> GetAllDBinSQL(ConnStringDataContract objconn)
        {
            List<DatabasesDataContract> objGetDBs = new List<DatabasesDataContract>();
            DataSet _ds = new DataSet();
            SqlDataAdapter _sda = new SqlDataAdapter();
            try
            {
                string strConnString = string.Empty;
                string myServerAddress = objconn.Server;
                string myUsername = objconn.UserName;
                string myPassword = objconn.Password;

                strConnString = "Data Source=" + myServerAddress + ";User ID=" + myUsername + ";Password=" + myPassword;

                sqlcon = new SqlConnection(strConnString);
                string sqlcommand = "SELECT name, database_id FROM sys.databases";
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
                sqlcon.Open();
                _sda.SelectCommand = new SqlCommand(sqlcommand, sqlcon);
                _sda.Fill(_ds);
                sqlcon.Close();

                foreach (DataRow drow in _ds.Tables[0].Rows)
                {
                    DatabasesDataContract objddc = new DatabasesDataContract();
                    objddc.DatabaseName = drow["name"].ToString();
                    objddc.DBId = Convert.ToInt32(drow["database_id"].ToString());

                    objGetDBs.Add(objddc);
                }
            }
            catch (Exception ex) {

            }
            finally
            {
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
            }
            return objGetDBs;
        }

Get a table schema from a SQL table using C#

public List<TableDetailsDataContract> GetTableDetails(string tableName, string strConnString)
        {
            List<TableDetailsDataContract> ListTabledtls = new List<TableDetailsDataContract>();

            DataSet _ds = new DataSet();
            SqlDataAdapter _sda = new SqlDataAdapter();
            try
            {
                sqlcon = new SqlConnection(strConnString);
                string sqlcommand = "SELECT c.name AS 'Column Name', t.name AS 'Data type', c.max_length AS 'Max Length', c.is_nullable, ISNULL(i.is_primary_key, 0) AS 'Primary Key' FROM sys.columns AS c INNER JOIN sys.types AS t ON c.system_type_id = t.system_type_id LEFT OUTER JOIN sys.index_columns AS ic ON ic.object_id = c.object_id AND ic.column_id = c.column_id LEFT OUTER JOIN sys.indexes AS i ON ic.object_id = i.object_id AND ic.index_id = i.index_id WHERE (c.object_id = OBJECT_ID('"+ tableName +"'))";
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
                sqlcon.Open();
                _sda.SelectCommand = new SqlCommand(sqlcommand, sqlcon);
                _sda.Fill(_ds);
                sqlcon.Close();

                foreach (DataRow drow in _ds.Tables[0].Rows)
                {
                    ListTabledtls.Add(new TableDetailsDataContract { Column = drow["Column Name"].ToString(), DataType = drow["Data type"].ToString(), IsNullable = Convert.ToBoolean(drow["is_nullable"]), size = Convert.ToInt32(drow["Max Length"].ToString()), isPrimaryKey = Convert.ToBoolean(drow["Primary Key"]) });
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
            }
            return ListTabledtls;
        }

Get All table name from a sql server database using WCF

 public class ConnStringDataContract
    {
        [DataMember]
        public string Server { get; set; }
        [DataMember]
        public string InitialCatalog { get; set; }
        [DataMember]
        public string UserName { get; set; }
        [DataMember]
        public string Password{ get; set; }
    }
 -------------------------------------------------------------------------------------------------------
public List<TablesDataContract> GetTables(ConnStringDataContract objconn)
        {
            List<TablesDataContract> Tables = new List<TablesDataContract>();

            DataSet _ds = new DataSet();
            SqlDataAdapter _sda = new SqlDataAdapter();
            try
            {
                string strConnString = string.Empty;
                string myServerAddress = objconn.Server;
                string myUsername = objconn.UserName;
                string myPassword = objconn.Password;
                string myInitialCatalog = objconn.InitialCatalog;

                strConnString = "Data Source=" + myServerAddress + ";Initial Catalog=" + myInitialCatalog + ";User ID=" + myUsername + ";Password=" + myPassword;

                sqlcon = new SqlConnection(strConnString);
                string sqlcommand = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE (TABLE_TYPE = 'BASE TABLE')";
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
                sqlcon.Open();
                _sda.SelectCommand = new SqlCommand(sqlcommand, sqlcon);
                _sda.Fill(_ds);
                sqlcon.Close();
               
                foreach (DataRow drow in _ds.Tables[0].Rows)
                {
                    Tables.Add(new TablesDataContract { TableName = drow["TABLE_NAME"].ToString() });
                }
            }
            catch (Exception ex)
            {
            }
            finally
            {
                if (sqlcon.State == ConnectionState.Open)
                {
                    sqlcon.Close();
                }
            }

            return Tables;
        }