/// <summary>
 /// Get a system parameter which is an integer.
 /// </summary>
 /// <param name="param">The parameter to get.</param>
 /// <returns>The value of the parameter.</returns>
 private int GetIntegerParameter(JET_param param)
 {
     int value = 0;
     string ignored;
     Api.JetGetSystemParameter(this.instance, this.sesid, param, ref value, out ignored, 0);
     return value;
 }

        /// <summary>
        /// Retrieve a boolean parameter.
        /// </summary>
        /// <param name="param">The parameter to retrieve.</param>
        /// <returns>The parameter value.</returns>
        private bool GetBooleanParameter(JET_param param)
        {
            int value = 0;
            string ignored;

            Api.JetGetSystemParameter(this.instance, JET_SESID.Nil, param, ref value, out ignored, 0);
            return 0 != value;
        }

 /// <summary>
 /// Get a system parameter which is a boolean.
 /// </summary>
 /// <param name="param">The parameter to get.</param>
 /// <returns>The value of the parameter.</returns>
 private bool GetBoolParameter(JET_param param)
 {
     int value = 0;
     string ignored;
     Api.JetGetSystemParameter(this.instance, this.sesid, param, ref value, out ignored, 0);
     return value != 0;
 }

 /// <summary>
 /// Set a system parameter which is a string.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private static void SetStringParameter(JET_param param, string value)
 {
     Api.JetSetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, 0, value);
 }

 /// <summary>
 /// Get a system parameter which is an IntPtr.
 /// </summary>
 /// <param name="param">The parameter to get.</param>
 /// <returns>The value of the parameter.</returns>
 private IntPtr GetIntPtrParameter(JET_param param)
 {
     IntPtr value = IntPtr.Zero;
     string ignored;
     Api.JetGetSystemParameter(this.instance, this.sesid, param, ref value, out ignored, 0);
     return value;
 }

 /// <summary>
 /// Set a system parameter which is an integer.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private void SetIntegerParameter(JET_param param, int value)
 {
     Api.JetSetSystemParameter(this.instance, this.sesid, param, value, null);
 }

 /// <summary>
 /// Initializes a new instance of the JetParameter class.
 /// </summary>
 /// <param name="param">The parameter identifier.</param>
 /// <param name="value">The value of the parameter.</param>
 public JetParameter(JET_param param, int value)
 {
     this.param = param;
     this.strValue = null;
     this.intValue = value;
 }

        /// <summary>
        /// Gets database configuration options.
        /// </summary>
        /// <param name="instance">The instance to retrieve the options from.</param>
        /// <param name="sesid">The session to use.</param>
        /// <param name="paramid">The parameter to get.</param>
        /// <param name="paramValue">Returns the value of the parameter, if the value is an integer.</param>
        /// <param name="paramString">Returns the value of the parameter, if the value is a string.</param>
        /// <param name="maxParam">The maximum size of the parameter string.</param>
        /// <returns>An ESENT warning code.</returns>
        /// <remarks>
        /// <see cref="JET_param.ErrorToString"/> passes in the error number in the paramValue, which is why it is
        /// a ref parameter and not an out parameter.
        /// </remarks>
        public static JET_wrn JetGetSystemParameter(JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, ref int paramValue, out string paramString, int maxParam)
        {
            var intValue = new IntPtr(paramValue);
            JET_wrn wrn = Api.Check(Impl.JetGetSystemParameter(instance, sesid, paramid, ref intValue, out paramString, maxParam));
            paramValue = intValue.ToInt32();

            return wrn;
        }

        /// <summary>
        /// Test setting and retrieving a system parameter that uses a path. A relative
        /// path is set but a full path is retrieved.
        /// </summary>
        /// <param name="param">The parameter to set.</param>
        /// <param name="expected">The path to set it to.</param>
        private static void PathParameterTest(JET_param param, string expected)
        {
            JET_INSTANCE instance;
            Api.JetCreateInstance(out instance, "PathParameterTest");
            try
            {
                Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, 0, expected);

                int ignored = 0;
                string actual;
                Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref ignored, out actual, 256);

                Assert.AreEqual(Path.Combine(Environment.CurrentDirectory, expected), actual);
            }
            finally
            {
                Api.JetTerm(instance);
            }
        }

 /// <summary>
 /// Set a system parameter which is an integer.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private static void SetIntegerParameter(JET_param param, int value)
 {
     Api.JetSetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, value, null);
 }

 /// <summary>
 /// Sets database configuration options.
 /// </summary>
 /// <param name="instance">
 /// The instance to set the option on or <see cref="JET_INSTANCE.Nil"/>
 /// to set the option on all instances.
 /// </param>
 /// <param name="sesid">The session to use.</param>
 /// <param name="paramid">The parameter to set.</param>
 /// <param name="paramValue">The value of the parameter to set, if the parameter is a JET_CALLBACK.</param>
 /// <param name="paramString">The value of the parameter to set, if the parameter is a string type.</param>
 /// <returns>An ESENT warning code.</returns>
 public static JET_wrn JetSetSystemParameter(JET_INSTANCE instance, JET_SESID sesid, JET_param paramid, JET_CALLBACK paramValue, string paramString)
 {
     return Api.Check(Impl.JetSetSystemParameter(instance, sesid, paramid, paramValue, paramString));
 }

 /// <summary>
 /// Set a system parameter which is a boolean.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private static void SetBoolParameter(JET_param param, bool value)
 {
     int setting = value ? 1 : 0;
     Api.JetSetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, 1, null);
 }

 /// <summary>
 /// Get a system parameter which is an integer.
 /// </summary>
 /// <param name="param">The parameter to get.</param>
 /// <returns>The value of the parameter.</returns>
 private static int GetIntegerParameter(JET_param param)
 {
     int value = 0;
     string ignored;
     Api.JetGetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, ref value, out ignored, 0);
     return value;
 }

 /// <summary>
 /// Gets database configuration options.
 /// </summary>
 /// <param name="instance">The instance to retrieve the options from.</param>
 /// <param name="sesid">The session to use.</param>
 /// <param name="paramid">The parameter to get.</param>
 /// <param name="paramValue">Returns the value of the parameter, if the value is an integer.</param>
 /// <param name="paramString">Returns the value of the parameter, if the value is a string.</param>
 /// <param name="maxParam">The maximum size of the parameter string.</param>
 /// <returns>An ESENT warning code.</returns>
 /// <remarks>
 /// <see cref="JET_param.ErrorToString"/> passes in the error number in the paramValue, which is why it is
 /// a ref parameter and not an out parameter.
 /// </remarks>
 public static JET_wrn JetGetSystemParameter(
     JET_INSTANCE instance,
     JET_SESID sesid,
     JET_param paramid,
     ref IntPtr paramValue,
     out string paramString,
     int maxParam)
 {
     return Api.Check(Impl.JetGetSystemParameter(instance, sesid, paramid, ref paramValue, out paramString, maxParam));
 }

 /// <summary>
 /// Get a system parameter which is a string.
 /// </summary>
 /// <param name="param">The parameter to get.</param>
 /// <returns>The value of the parameter.</returns>
 private string GetStringParameter(JET_param param)
 {
     int ignored = 0;
     string value;
     Api.JetGetSystemParameter(this.instance, this.sesid, param, ref ignored, out value, 1024);
     return value;
 }

        /// <summary>
        /// Test setting and retrieving a system parameter that uses a string.
        /// </summary>
        /// <param name="param">The parameter to set.</param>
        /// <param name="expected">The string to set it to.</param>
        private static void StringParameterTest(JET_param param, string expected)
        {
            JET_INSTANCE instance;
            Api.JetCreateInstance(out instance, "StringParameterTest");
            try
            {
                Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, 0, expected);

                int ignored = 0;
                string actual;
                Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref ignored, out actual, 256);

                Assert.AreEqual(expected, actual);
            }
            finally
            {
                Api.JetTerm(instance);
            }
        }

 /// <summary>
 /// Set a system parameter which is a boolean.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private void SetBoolParameter(JET_param param, bool value)
 {
     if (value)
     {
         Api.JetSetSystemParameter(this.instance, this.sesid, param, 1, null);
     }
     else
     {
         Api.JetSetSystemParameter(this.instance, this.sesid, param, 0, null);
     }
 }

        /// <summary>
        /// Test setting and retrieving an integer system parameter.
        /// </summary>
        /// <param name="param">The parameter to set.</param>
        /// <param name="expected">The string to set it to.</param>
        private static void IntegerParameterTest(JET_param param, int expected)
        {
            JET_INSTANCE instance;
            Api.JetCreateInstance(out instance, "IntParameterTest");
            try
            {
                Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, expected, null);

                int actual = 0;
                string ignored;
                Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref actual, out ignored, 0);

                Assert.AreEqual(expected, actual);
            }
            finally
            {
                Api.JetTerm(instance);
            }
        }

 /// <summary>
 /// Set a system parameter which is a string.
 /// </summary>
 /// <param name="param">The parameter to set.</param>
 /// <param name="value">The value to set.</param>
 private void SetStringParameter(JET_param param, string value)
 {
     Api.JetSetSystemParameter(this.instance, this.sesid, param, 0, value);
 }

        /// <summary>
        /// Test setting and retrieving an integer system parameter which
        /// is treated as a boolean.
        /// </summary>
        /// <param name="param">The parameter to set.</param>
        /// <param name="expected">The string to set it to.</param>
        private static void BooleanParameterTest(JET_param param, bool expected)
        {
            int value = expected ? 1 : 0;

            JET_INSTANCE instance;
            Api.JetCreateInstance(out instance, "BoolParameterTest");
            try
            {
                Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, value, null);

                int actual = 0;
                string ignored;
                Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref actual, out ignored, 0);

                if (expected)
                {
                    Assert.AreNotEqual(0, actual);
                }
                else
                {
                    Assert.AreEqual(0, actual);
                }
            }
            finally
            {
                Api.JetTerm(instance);
            }
        }