internal static string[] GetDatabaseTableExtendedPropertiesLike(string connectionString, string tableName, string likeStatement)
{
ArrayList propertyNames = new ArrayList();
SqlDataReader propertyReader = null;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
try
{
conn.ConnectionString = connectionString;
conn.Open();
SqlCommand cmdCreateDb = new SqlCommand();
cmdCreateDb.CommandText = GetSqlForTableExtendedPropertyLikeCount(tableName, likeStatement);
cmdCreateDb.CommandType = System.Data.CommandType.Text;
cmdCreateDb.Connection = conn;
propertyReader = cmdCreateDb.ExecuteReader();
while(propertyReader.Read())
{
propertyNames.Add(propertyReader.GetString(0));
}
}
catch(Exception ex)
{
throw ex;
}
finally
{
if(propertyReader != null)
propertyReader.Close();
if(conn != null)
conn.Close();
}
return (string[])propertyNames.ToArray(typeof(string));
}