/// <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); #if MANAGEDESENT_ON_WSA // We can't fetch the full path in Windows Store Apps, but we can check if the last part of the path is correct. Assert.IsNotNull(actual); Assert.IsTrue(actual.EndsWith(expected)); #else Assert.AreEqual(Path.GetFullPath(expected), actual); #endif } finally { Api.JetTerm(instance); } }
/// <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); } }
/// <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 static string GetStringParameter(JET_param param) { int ignored = 0; string value; Api.JetGetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, ref ignored, out value, 1024); 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> /// Retrieve an integer parameter. /// </summary> /// <param name="param">The parameter to retrieve.</param> /// <returns>The parameter value.</returns> private int GetIntegerParameter(JET_param param) { int value = 0; string ignored; Api.JetGetSystemParameter(this.instance, JET_SESID.Nil, param, ref value, out ignored, 0); return(value); }
/// <summary> /// Calls JetGetSystemParamter to return a JET_param value. /// </summary> /// <param name="instance">The instance to use.</param> /// <param name="param">The param to get.</param> /// <returns>The parameter value as an integer.</returns> private int GetIntParam(JET_INSTANCE instance, JET_param param) { int value = 0; string dummy; Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref value, out dummy, 0); return(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> /// Calls JetGetSystemParamter to return a JET_param value. /// </summary> /// <param name="instance">The instance to use.</param> /// <param name="param">The param to get.</param> /// <returns>The parameter value as an integer.</returns> private string GetStringParam(JET_INSTANCE instance, JET_param param) { int dummy = 0; string value; Api.JetGetSystemParameter(instance, JET_SESID.Nil, param, ref dummy, out value, 260); return(value); }
/// <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); }
public void VerifyGetIntegerParameterHelperGetsParameter() { const int Expected = 100; JET_param param = JET_param.MaxOpenTables; Api.JetSetSystemParameter(this.instance, JET_SESID.Nil, param, Expected, string.Empty); Assert.AreEqual(Expected, this.GetIntegerParameter(param)); }
/// <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 static bool GetBoolParameter(JET_param param) { int value = 0; string ignored; Api.JetGetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, ref value, out ignored, 0); return(value != 0); }
public void VerifyGetStringParameterHelperGetsParameter() { string expected = Any.String; JET_param param = JET_param.EventSource; Api.JetSetSystemParameter(this.instance, JET_SESID.Nil, param, 0, expected); Assert.AreEqual(expected, this.GetStringParameter(param)); }
/// <summary> /// Test setting and retrieving an integer system parameter. /// </summary> /// <param name="instance">The ESE instance.</param> /// <param name="param">The parameter to set.</param> /// <param name="expected">The string to set it to.</param> private static void IntegerParameterTest(JET_INSTANCE instance, JET_param param, int expected) { 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); }
/// <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 a system parameter that uses a string. /// </summary> /// <param name="instance">The ESE instance.</param> /// <param name="param">The parameter to set.</param> /// <param name="expected">The string to expect when reading the parameter.</param> private static void StringParameterTest(JET_INSTANCE instance, JET_param param, string expected) { 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); }
/// <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 { SetGetSystemParameterTests.StringParameterTest(instance, param, expected); } finally { Api.JetTerm(instance); } }
/// <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 { SetGetSystemParameterTests.IntegerParameterTest(instance, param, expected); } finally { Api.JetTerm(instance); } }
/// <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) { JET_INSTANCE instance; Api.JetCreateInstance(out instance, "BoolParameterTest"); try { SetGetSystemParameterTests.BooleanParameterTest(instance, param, expected); } finally { Api.JetTerm(instance); } }
/// <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> /// 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> /// 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> /// 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> /// Sets an integer param on an Ese instance. /// </summary> /// <param name="instance">The instance handle.</param> /// <param name="param">The param to set.</param> /// <param name="value">The param value.</param> private void SetParam(JET_INSTANCE instance, JET_param param, int value) { Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, value, null); }
/// <summary> /// Sets a string param on an Ese instance. /// </summary> /// <param name="instance">The instance handle.</param> /// <param name="param">The param to set.</param> /// <param name="value">The param value.</param> private void SetParam(JET_INSTANCE instance, JET_param param, string value) { Api.JetSetSystemParameter(instance, JET_SESID.Nil, param, 0, 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> /// 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> /// 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 static string GetStringParameter(JET_param param) { int ignored = 0; string value; Api.JetGetSystemParameter(JET_INSTANCE.Nil, JET_SESID.Nil, param, ref ignored, out value, 1024); return value; }
/// <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> /// 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> /// 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> /// 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 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> /// 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> /// 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 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> /// 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> /// 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 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> /// 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> /// 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, setting, 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, string value) { this.param = param; this.strValue = value; this.intValue = 0; }