/// <summary>
/// Sets data file and transaction log file properties for this database.
/// </summary>
/// <param name="props">
/// A list of properties to set.
/// </param>
/// <remarks>
/// Only the data file and transaction log file properties are used.
/// You cannot set the owner, create date, etc. properties of the database.
/// </remarks>
public void SetDatabaseProperties(SqlDatabaseProperties props)
{
NativeMethods.IDBFile dataFile = dmoDatabase.GetFileGroups().Item(1).GetDBFiles().Item(1);
NativeMethods.ILogFile logFile = dmoDatabase.GetTransactionLog().GetLogFiles().Item(1);
dataFile.SetFileGrowthType((props.DataFile.FileGrowthType == SqlFileGrowthType.MB) ? NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB : NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent);
dataFile.SetFileGrowth(props.DataFile.FileGrowth);
dataFile.SetMaximumSize(props.DataFile.MaximumSize);
logFile.SetFileGrowthType((props.LogFile.FileGrowthType == SqlFileGrowthType.MB) ? NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB : NativeMethods.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent);
logFile.SetFileGrowth(props.LogFile.FileGrowth);
logFile.SetMaximumSize(props.LogFile.MaximumSize);
}
