//-----------------------------------------------------------------------
// <copyright file="NativeMethods.cs" company="Microsoft Corporation">
//     Copyright (c) Microsoft Corporation.
// </copyright>
//-----------------------------------------------------------------------

namespace Microsoft.Isam.Esent.Interop.Implementation
{
    using System;
    using System.Runtime.InteropServices;
    using System.Security;
    using System.Text;
    using Microsoft.Isam.Esent.Interop.Vista;

    /// <summary>
    /// Native interop for functions in esent.dll.
    /// </summary>
    [SuppressUnmanagedCodeSecurity]
    [BestFitMapping(false, ThrowOnUnmappableChar = true)]
    internal static partial class NativeMethods
    {
        #region Configuration Constants

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        /// <summary>
        /// The CharSet for the methods in the DLL.
        /// </summary>
        private const CharSet EsentCharSet = CharSet.Ansi;

        /// <summary>
        /// Initializes static members of the NativeMethods class.
        /// </summary>
        static NativeMethods()
        {
            // This must be changed when the CharSet is changed.
            NativeMethods.Encoding = LibraryHelpers.EncodingASCII;
        }

        /// <summary>
        /// Gets encoding to be used when converting data to/from byte arrays.
        /// This should match the CharSet above.
        /// </summary>
        public static Encoding Encoding { get; private set; }
#endif // !MANAGEDESENT_ON_WSA

        #endregion Configuration Constants

        #region init/term

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateInstance(out IntPtr instance, string szInstanceName);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateInstanceW(out IntPtr instance, string szInstanceName);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateInstance2(out IntPtr instance, string szInstanceName, string szDisplayName, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateInstance2W(out IntPtr instance, string szInstanceName, string szDisplayName, uint grbit);

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetInit(ref IntPtr instance);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetInit2(ref IntPtr instance, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        // JetInit3 was introduced in Vista, so therefore we'll only support the Unicode version.
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetInit3W(ref IntPtr instance, ref NATIVE_RSTINFO prstinfo, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetInit3W(ref IntPtr instance, IntPtr prstinfo, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetGetInstanceInfo(out uint pcInstanceInfo, out NATIVE_INSTANCE_INFO* prgInstanceInfo);

        // Returns unicode strings in the NATIVE_INSTANCE_INFO.
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetGetInstanceInfoW(out uint pcInstanceInfo, out NATIVE_INSTANCE_INFO* prgInstanceInfo);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetInstanceMiscInfo(IntPtr instance, ref NATIVE_SIGNATURE pvResult, uint cbMax, uint infoLevel);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetStopBackupInstance(IntPtr instance);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetStopServiceInstance(IntPtr instance);

#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetStopServiceInstance2(IntPtr instance, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetTerm(IntPtr instance);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetTerm2(IntPtr instance, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static unsafe extern int JetSetSystemParameter(IntPtr* pinstance, IntPtr sesid, uint paramid, IntPtr lParam, string szParam);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static unsafe extern int JetSetSystemParameterW(IntPtr* pinstance, IntPtr sesid, uint paramid, IntPtr lParam, string szParam);

        // The param is ref because it is an 'in' parameter when getting error text
#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetSystemParameter(IntPtr instance, IntPtr sesid, uint paramid, ref IntPtr plParam, [Out] StringBuilder szParam, uint cbMax);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetSystemParameterW(IntPtr instance, IntPtr sesid, uint paramid, ref IntPtr plParam, [Out] StringBuilder szParam, uint cbMax);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetVersion(IntPtr sesid, out uint dwVersion);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region Databases

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateDatabase(IntPtr sesid, string szFilename, string szConnect, out uint dbid, uint grbit);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateDatabaseW(IntPtr sesid, string szFilename, string szConnect, out uint dbid, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateDatabase2(IntPtr sesid, string szFilename, uint cpgDatabaseSizeMax, out uint dbid, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateDatabase2W(IntPtr sesid, string szFilename, uint cpgDatabaseSizeMax, out uint dbid, uint grbit);

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetAttachDatabase(IntPtr sesid, string szFilename, uint grbit);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetAttachDatabaseW(IntPtr sesid, string szFilename, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetAttachDatabase2(IntPtr sesid, string szFilename, uint cpgDatabaseSizeMax, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetAttachDatabase2W(IntPtr sesid, string szFilename, uint cpgDatabaseSizeMax, uint grbit);

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDetachDatabase(IntPtr sesid, string szFilename);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDetachDatabase2(IntPtr sesid, string szFilename, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDetachDatabase2W(IntPtr sesid, string szFilename, uint grbit);

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDetachDatabaseW(IntPtr sesid, string szFilename);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetOpenDatabase(IntPtr sesid, string database, string szConnect, out uint dbid, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetOpenDatabaseW(IntPtr sesid, string database, string szConnect, out uint dbid, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetCloseDatabase(IntPtr sesid, uint dbid, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCompact(
            IntPtr sesid, string szDatabaseSrc, string szDatabaseDest, IntPtr pfnStatus, IntPtr pconvert, uint grbit);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCompactW(
            IntPtr sesid, string szDatabaseSrc, string szDatabaseDest, IntPtr pfnStatus, IntPtr pconvert, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGrowDatabase(IntPtr sesid, uint dbid, uint cpg, out uint pcpgReal);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetDatabaseSize(IntPtr sesid, string szDatabaseName, uint cpg, out uint pcpgReal);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetSetDatabaseSizeW(IntPtr sesid, string szDatabaseName, uint cpg, out uint pcpgReal);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfo(IntPtr sesid, uint dbid, out int intValue, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfo(IntPtr sesid, uint dbid, out NATIVE_DBINFOMISC dbinfomisc, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfo(IntPtr sesid, uint dbid, out NATIVE_DBINFOMISC4 dbinfomisc, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfo(IntPtr sesid, uint dbid, [Out] StringBuilder stringValue, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfoW(IntPtr sesid, uint dbid, out int intValue, uint cbMax, uint InfoLevel);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfoW(IntPtr sesid, uint dbid, out NATIVE_DBINFOMISC dbinfomisc, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfoW(IntPtr sesid, uint dbid, out NATIVE_DBINFOMISC4 dbinfomisc, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseInfoW(IntPtr sesid, uint dbid, [Out] StringBuilder stringValue, uint cbMax, uint InfoLevel);

        #endregion

        #region JetGetDatabaseFileInfo

        // Unicode, int
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfoW(string szFilename, out int intValue, uint cbMax, uint InfoLevel);

#if !MANAGEDESENT_ON_WSA
        // ASCII, int
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfo(string szFilename, out int intValue, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        // Unicode, long
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfoW(string szFilename, out long intValue, uint cbMax, uint InfoLevel);

#if !MANAGEDESENT_ON_WSA
        // ASCII, long
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfo(string szFilename, out long intValue, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        // Unicode, JET_DBINFOMISC4
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfoW(string szFilename, out NATIVE_DBINFOMISC4 dbinfomisc, uint cbMax, uint InfoLevel);

#if !MANAGEDESENT_ON_WSA
        // ASCII, JET_DBINFOMISC
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfo(string szFilename, out NATIVE_DBINFOMISC dbinfomisc, uint cbMax, uint InfoLevel);

        // Unicode, JET_DBINFOMISC
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetDatabaseFileInfoW(string szFilename, out NATIVE_DBINFOMISC dbinfomisc, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region Backup/Restore

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetBackupInstance(
            IntPtr instance, string szBackupPath, uint grbit, IntPtr pfnStatus);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetBackupInstanceW(
            IntPtr instance, string szBackupPath, uint grbit, IntPtr pfnStatus);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetRestoreInstance(IntPtr instance, string sz, string szDest, IntPtr pfn);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetRestoreInstanceW(IntPtr instance, string sz, string szDest, IntPtr pfn);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region Snapshot Backup

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotPrepare(out IntPtr snapId, uint grbit);

        // Introduced in Windows Vista
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotPrepareInstance(IntPtr snapId, IntPtr instance, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetOSSnapshotFreeze(
            IntPtr snapId,
            out uint pcInstanceInfo,
            out NATIVE_INSTANCE_INFO* prgInstanceInfo,
            uint grbit);

        // Returns unicode strings in the NATIVE_INSTANCE_INFO.
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetOSSnapshotFreezeW(
            IntPtr snapId,
            out uint pcInstanceInfo,
            out NATIVE_INSTANCE_INFO* prgInstanceInfo,
            uint grbit);

        // Introduced in Windows Vista
        // Returns unicode strings in the NATIVE_INSTANCE_INFO.
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetOSSnapshotGetFreezeInfoW(
            IntPtr snapId,
            out uint pcInstanceInfo,
            out NATIVE_INSTANCE_INFO* prgInstanceInfo,
            uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotThaw(IntPtr snapId, uint grbit);

        // Introduced in Windows Vista
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotTruncateLog(IntPtr snapId, uint grbit);

        // Introduced in Windows Vista
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotTruncateLogInstance(IntPtr snapId, IntPtr instance, uint grbit);

        // Introduced in Windows Vista
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotEnd(IntPtr snapId, uint grbit);

        // Introduced in Windows Server 2003
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOSSnapshotAbort(IntPtr snapId, uint grbit);
#endif // !MANAGEDESENT_ON_WSA
        #endregion

        #region Snapshot Backup/Restore

#if !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetBeginExternalBackupInstance(IntPtr instance, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetCloseFileInstance(IntPtr instance, IntPtr handle);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetEndExternalBackupInstance(IntPtr instance);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetEndExternalBackupInstance2(IntPtr instance, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetAttachInfoInstance(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetAttachInfoInstanceW(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetLogInfoInstance(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetLogInfoInstanceW(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTruncateLogInfoInstance(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTruncateLogInfoInstanceW(IntPtr instance, [Out] byte[] szz, uint cbMax, out uint pcbActual);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetOpenFileInstance(
            IntPtr instance, string szFileName, out IntPtr phfFile, out uint pulFileSizeLow, out uint pulFileSizeHigh);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetOpenFileInstanceW(
            IntPtr instance, string szFileName, out IntPtr phfFile, out uint pulFileSizeLow, out uint pulFileSizeHigh);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetReadFileInstance(
            IntPtr instance, IntPtr handle, IntPtr pv, uint cb, out uint pcbActual);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetTruncateLogInstance(IntPtr instance);
#endif // !MANAGEDESENT_ON_WSA
        #endregion

        #region sessions

#if MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetBeginSessionW(IntPtr instance, out IntPtr session, string username, string password);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetBeginSession(IntPtr instance, out IntPtr session, string username, string password);
#endif

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetSessionContext(IntPtr session, IntPtr context);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetResetSessionContext(IntPtr session);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetEndSession(IntPtr sesid, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetDupSession(IntPtr sesid, out IntPtr newSesid);
#endif

        [DllImport(EsentDll, ExactSpelling = true)]
        public static unsafe extern int JetGetThreadStats(JET_THREADSTATS* pvResult, uint cbMax);

        #endregion

        #region tables

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetOpenTable(IntPtr sesid, uint dbid, string tablename, byte[] pvParameters, uint cbParameters, uint grbit, out IntPtr tableid);
#endif

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetOpenTableW(IntPtr sesid, uint dbid, string tablename, byte[] pvParameters, uint cbParameters, uint grbit, out IntPtr tableid);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetCloseTable(IntPtr sesid, IntPtr tableid);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetDupCursor(IntPtr sesid, IntPtr tableid, out IntPtr tableidNew, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetComputeStats(IntPtr sesid, IntPtr tableid);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetLS(IntPtr sesid, IntPtr tableid, IntPtr ls, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetLS(IntPtr sesid, IntPtr tableid, out IntPtr pls, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetCursorInfo(IntPtr sesid, IntPtr tableid, IntPtr pvResult, uint cbMax, uint infoLevel);
#endif // !MANAGEDESENT_ON_WSA
        #endregion

        #region transactions

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetBeginTransaction(IntPtr sesid);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetBeginTransaction2(IntPtr sesid, uint grbit);
#endif // !MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetBeginTransaction3(IntPtr sesid, long trxid, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetCommitTransaction(IntPtr sesid, uint grbit);
#endif

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetRollback(IntPtr sesid, uint grbit);

        #endregion

        #region DDL

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateTable(IntPtr sesid, uint dbid, string szTableName, int pages, int density, out IntPtr tableid);
#endif

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetAddColumnW(IntPtr sesid, IntPtr tableid, string szColumnName, [In] ref NATIVE_COLUMNDEF columndef, [In] byte[] pvDefault, uint cbDefault, out uint columnid);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetAddColumn(IntPtr sesid, IntPtr tableid, string szColumnName, [In] ref NATIVE_COLUMNDEF columndef, [In] byte[] pvDefault, uint cbDefault, out uint columnid);
#endif

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDeleteColumn(IntPtr sesid, IntPtr tableid, string szColumnName);
#endif

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDeleteColumn2W(IntPtr sesid, IntPtr tableid, string szColumnName, uint grbit);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDeleteColumn2(IntPtr sesid, IntPtr tableid, string szColumnName, uint grbit);
#endif

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDeleteIndexW(IntPtr sesid, IntPtr tableid, string szIndexName);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDeleteIndex(IntPtr sesid, IntPtr tableid, string szIndexName);
#endif

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDeleteTableW(IntPtr sesid, uint dbid, string szTableName);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDeleteTable(IntPtr sesid, uint dbid, string szTableName);
#endif

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateIndex(IntPtr sesid, IntPtr tableid, string szIndexName, uint grbit, string szKey, uint cbKey, uint lDensity);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateIndex2(
            IntPtr sesid, IntPtr tableid, [In] JET_INDEXCREATE.NATIVE_INDEXCREATE[] pindexcreate, uint cIndexCreate);

        // Introduced in Windows Vista, this version takes the larger NATIVE_INDEXCREATE1 structure.
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateIndex2W(
            IntPtr sesid, IntPtr tableid, [In] JET_INDEXCREATE.NATIVE_INDEXCREATE1[] pindexcreate, uint cIndexCreate);

        // Introduced in Windows 7, this version takes the larger NATIVE_INDEXCREATE2 structure, supporting
        // space hints.
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateIndex3W(
            IntPtr sesid, IntPtr tableid, [In] JET_INDEXCREATE.NATIVE_INDEXCREATE2[] pindexcreate, uint cIndexCreate);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOpenTempTable(
            IntPtr sesid,
            [In] NATIVE_COLUMNDEF[] rgcolumndef,
            uint ccolumn,
            uint grbit,
            out IntPtr ptableid,
            [Out] uint[] rgcolumnid);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOpenTempTable2(
            IntPtr sesid,
            [In] NATIVE_COLUMNDEF[] rgcolumndef,
            uint ccolumn,
            uint lcid,
            uint grbit,
            out IntPtr ptableid,
            [Out] uint[] rgcolumnid);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOpenTempTable3(
            IntPtr sesid,
            [In] NATIVE_COLUMNDEF[] rgcolumndef,
            uint ccolumn,
            [In] ref NATIVE_UNICODEINDEX pidxunicode,
            uint grbit,
            out IntPtr ptableid,
            [Out] uint[] rgcolumnid);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        // Introduced in Windows Vista
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOpenTemporaryTable(IntPtr sesid, [In] [Out] ref NATIVE_OPENTEMPORARYTABLE popentemporarytable);
#endif // !MANAGEDESENT_ON_WSA

        // Overload to allow for null pidxunicode
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetOpenTempTable3(
            IntPtr sesid,
            [In] NATIVE_COLUMNDEF[] rgcolumndef,
            uint ccolumn,
            IntPtr pidxunicode,
            uint grbit,
            out IntPtr ptableid,
            [Out] uint[] rgcolumnid);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetCreateTableColumnIndex2(IntPtr sesid, uint dbid, ref JET_TABLECREATE.NATIVE_TABLECREATE2 tablecreate3);

        // Introduced in Vista.
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateTableColumnIndex2W(IntPtr sesid, uint dbid, ref JET_TABLECREATE.NATIVE_TABLECREATE2 tablecreate3);

        // Introduced in Windows 7
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetCreateTableColumnIndex3W(IntPtr sesid, uint dbid, ref JET_TABLECREATE.NATIVE_TABLECREATE3 tablecreate3);
#endif // !MANAGEDESENT_ON_WSA

        #region JetGetTableColumnInfo overlaods.
#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, ref uint pcolumnid, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, string szColumnName, ref NATIVE_COLUMNBASE columnbase, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, string szIgnored, ref NATIVE_COLUMNLIST columnlist, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, ref uint pcolumnid, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, string szColumnName, ref NATIVE_COLUMNBASE_WIDE columnbase, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, ref uint pcolumnid, ref NATIVE_COLUMNBASE_WIDE columnbase, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, string szIgnored, ref NATIVE_COLUMNLIST columnlist, uint cbMax, uint InfoLevel);
        #endregion

        #region JetGetColumnInfo overlaods.
#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNLIST columnlist, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNBASE columnbase, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, ref uint pcolumnid, ref NATIVE_COLUMNBASE columnbase, uint cbMax, uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetColumnInfoW(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetColumnInfoW(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNLIST columnlist, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetColumnInfoW(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNBASE_WIDE columnbase, uint cbMax, uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetColumnInfoW(IntPtr sesid, uint dbid, string szTableName, ref uint pcolumnid, ref NATIVE_COLUMNBASE_WIDE columnbase, uint cbMax, uint InfoLevel);
        #endregion

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetObjectInfo(
            IntPtr sesid,
            uint dbid,
            uint objtyp,
            string szContainerName,
            string szObjectName,
            [In] [Out] ref NATIVE_OBJECTLIST objectlist,
            uint cbMax,
            uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetObjectInfoW(
            IntPtr sesid,
            uint dbid,
            uint objtyp,
            string szContainerName,
            string szObjectName,
            [In] [Out] ref NATIVE_OBJECTLIST objectlist,
            uint cbMax,
            uint InfoLevel);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetObjectInfo(
            IntPtr sesid,
            uint dbid,
            uint objtyp,
            string szContainerName,
            string szObjectName,
            [In] [Out] ref NATIVE_OBJECTINFO objectinfo,
            uint cbMax,
            uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetObjectInfoW(
            IntPtr sesid,
            uint dbid,
            uint objtyp,
            string szContainerName,
            string szObjectName,
            [In] [Out] ref NATIVE_OBJECTINFO objectinfo,
            uint cbMax,
            uint InfoLevel);

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetCurrentIndexW(IntPtr sesid, IntPtr tableid, [Out] StringBuilder szIndexName, uint cchIndexName);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetCurrentIndex(IntPtr sesid, IntPtr tableid, [Out] StringBuilder szIndexName, uint cchIndexName);
#endif

        #region JetGetTableInfo overloads

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableInfo(
            IntPtr sesid,
            IntPtr tableid,
            [Out] out NATIVE_OBJECTINFO pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableInfo(
            IntPtr sesid,
            IntPtr tableid,
            [Out] out uint pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableInfo(
            IntPtr sesid,
            IntPtr tableid,
            [Out] int[] pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableInfo(
            IntPtr sesid,
            IntPtr tableid,
            [Out] StringBuilder pvResult,
            uint cbMax,
            uint infoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableInfoW(
            IntPtr sesid,
            IntPtr tableid,
            [Out] out NATIVE_OBJECTINFO pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableInfoW(
            IntPtr sesid,
            IntPtr tableid,
            [Out] out uint pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableInfoW(
            IntPtr sesid,
            IntPtr tableid,
            [Out] int[] pvResult,
            uint cbMax,
            uint infoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableInfoW(
            IntPtr sesid,
            IntPtr tableid,
            [Out] StringBuilder pvResult,
            uint cbMax,
            uint infoLevel);

        #endregion

        #region JetGetIndexInfo overloads

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetIndexInfo(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out ushort result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetIndexInfo(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out uint result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetIndexInfo(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out JET_INDEXID result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetIndexInfo(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [In] [Out] ref NATIVE_INDEXLIST result,
            uint cbResult,
            uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out ushort result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out uint result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] out JET_INDEXID result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [In] [Out] ref NATIVE_INDEXLIST result,
            uint cbResult,
            uint InfoLevel);

        // Meant for NATIVE_INDEXCREATE3. I had some trouble doing [In] [Out] ref NATIVE_INDEXCREATE3.
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [In] IntPtr result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetIndexInfoW(
            IntPtr sesid,
            uint dbid,
            string szTableName,
            string szIndexName,
            [Out] StringBuilder result,
            uint cbResult,
            uint InfoLevel);

        #endregion

        #region JetGetTableIndexInfo overloads

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfo(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out ushort result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfo(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out uint result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfo(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out JET_INDEXID result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfo(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [In] [Out] ref NATIVE_INDEXLIST result,
            uint cbResult,
            uint InfoLevel);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out ushort result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out uint result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] out JET_INDEXID result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [In] [Out] ref NATIVE_INDEXLIST result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [In] IntPtr result,
            uint cbResult,
            uint InfoLevel);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetGetTableIndexInfoW(
            IntPtr sesid,
            IntPtr tableid,
            string szIndexName,
            [Out] StringBuilder result,
            uint cbResult,
            uint InfoLevel);

        #endregion

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetRenameTableW(IntPtr sesid, uint dbid, string szName, string szNameNew);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetRenameTable(IntPtr sesid, uint dbid, string szName, string szNameNew);
#endif // !MANAGEDESENT_ON_WSA

#if MANAGEDESENT_ON_WSA
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetRenameColumnW(IntPtr sesid, IntPtr tableid, string szName, string szNameNew, uint grbit);
#else
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetRenameColumn(IntPtr sesid, IntPtr tableid, string szName, string szNameNew, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetColumnDefaultValue(
            IntPtr sesid, uint tableid, [MarshalAs(UnmanagedType.LPStr)] string szTableName, [MarshalAs(UnmanagedType.LPStr)] string szColumnName, byte[] pvData, uint cbData, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region Navigation

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGotoBookmark(IntPtr sesid, IntPtr tableid, [In] byte[] pvBookmark, uint cbBookmark);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGotoSecondaryIndexBookmark(
            IntPtr sesid,
            IntPtr tableid,
            [In] byte[] pvSecondaryKey,
            uint cbSecondaryKey,
            [In] byte[] pvPrimaryBookmark,
            uint cbPrimaryBookmark,
            uint grbit);

        // This has IntPtr and NATIVE_RETINFO versions because the parameter can be null
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetMove(IntPtr sesid, IntPtr tableid, int cRow, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetMakeKey(IntPtr sesid, IntPtr tableid, IntPtr pvData, uint cbData, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSeek(IntPtr sesid, IntPtr tableid, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetIndexRange(IntPtr sesid, IntPtr tableid, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetIntersectIndexes(
            IntPtr sesid,
            [In] NATIVE_INDEXRANGE[] rgindexrange,
            uint cindexrange,
            [In] [Out] ref NATIVE_RECORDLIST recordlist,
            uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex(IntPtr sesid, IntPtr tableid, string szIndexName);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex2(IntPtr sesid, IntPtr tableid, string szIndexName, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex3(IntPtr sesid, IntPtr tableid, string szIndexName, uint grbit, uint itagSequence);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex4(IntPtr sesid, IntPtr tableid, string szIndexName, [In] ref JET_INDEXID indexid, uint grbit, uint itagSequence);
#else
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex4W(IntPtr sesid, IntPtr tableid, string szIndexName, [In] ref JET_INDEXID indexid, uint grbit, uint itagSequence);

        // This overload allows a null indexid.
        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetSetCurrentIndex4W(IntPtr sesid, IntPtr tableid, string szIndexName, [In] IntPtr indexid, uint grbit, uint itagSequence);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetIndexRecordCount(IntPtr sesid, IntPtr tableid, out uint crec, uint crecMax);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetIndexRecordCount2(IntPtr sesid, IntPtr tableid, out ulong crec, ulong crecMax);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetTableSequential(IntPtr sesid, IntPtr tableid, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetResetTableSequential(IntPtr sesid, IntPtr tableid, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetRecordPosition(IntPtr sesid, IntPtr tableid, out NATIVE_RECPOS precpos, uint cbRecpos);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGotoPosition(IntPtr sesid, IntPtr tableid, [In] ref NATIVE_RECPOS precpos);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static unsafe extern int JetPrereadKeys(
            IntPtr sesid, IntPtr tableid, void** rgpvKeys, uint* rgcbKeys, int ckeys, out int pckeysPreread, uint grbit);

        #endregion

        #region Data Retrieval

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetBookmark(IntPtr sesid, IntPtr tableid, [Out] byte[] pvBookmark, uint cbMax, out uint cbActual);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetSecondaryIndexBookmark(
            IntPtr sesid,
            IntPtr tableid,
            [Out] byte[] secondaryKey,
            uint secondaryKeySize,
            out uint actualSecondaryKeySize,
            [Out] byte[] primaryKey,
            uint primaryKeySize,
            out uint actualPrimaryKeySize,
            uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetRetrieveColumn(IntPtr sesid, IntPtr tableid, uint columnid, IntPtr pvData, uint cbData, out uint cbActual, uint grbit, IntPtr pretinfo);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetRetrieveColumn(
            IntPtr sesid,
            IntPtr tableid,
            uint columnid,
            IntPtr pvData,
            uint cbData,
            out uint cbActual,
            uint grbit,
            [In] [Out] ref NATIVE_RETINFO pretinfo);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static unsafe extern int JetRetrieveColumns(
            IntPtr sesid, IntPtr tableid, [In] [Out] NATIVE_RETRIEVECOLUMN* psetcolumn, uint csetcolumn);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetRetrieveKey(IntPtr sesid, IntPtr tableid, [Out] byte[] pvData, uint cbMax, out uint cbActual, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern unsafe int JetEnumerateColumns(
            IntPtr sesid,
            IntPtr tableid,
            uint cEnumColumnId,
            NATIVE_ENUMCOLUMNID* rgEnumColumnId,
            out uint pcEnumColumn,
            out NATIVE_ENUMCOLUMN* prgEnumColumn,
            JET_PFNREALLOC pfnRealloc,
            IntPtr pvReallocContext,
            uint cbDataMost,
            uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetRecordSize(
            IntPtr sesid, IntPtr tableid, ref NATIVE_RECSIZE precsize, uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetRecordSize2(
            IntPtr sesid, IntPtr tableid, ref NATIVE_RECSIZE2 precsize, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region DML

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetDelete(IntPtr sesid, IntPtr tableid);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetPrepareUpdate(IntPtr sesid, IntPtr tableid, uint prep);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetUpdate(IntPtr sesid, IntPtr tableid, [Out] byte[] pvBookmark, uint cbBookmark, out uint cbActual);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetUpdate2(IntPtr sesid, IntPtr tableid, [Out] byte[] pvBookmark, uint cbBookmark, out uint cbActual, uint grbit);

        // This has IntPtr and NATIVE_SETINFO versions because the parameter can be null
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetColumn(IntPtr sesid, IntPtr tableid, uint columnid, IntPtr pvData, uint cbData, uint grbit, IntPtr psetinfo);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetSetColumn(IntPtr sesid, IntPtr tableid, uint columnid, IntPtr pvData, uint cbData, uint grbit, [In] ref NATIVE_SETINFO psetinfo);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static unsafe extern int JetSetColumns(
            IntPtr sesid, IntPtr tableid, [In] [Out] NATIVE_SETCOLUMN* psetcolumn, uint csetcolumn);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetGetLock(IntPtr sesid, IntPtr tableid, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetEscrowUpdate(
            IntPtr sesid,
            IntPtr tableid,
            uint columnid,
            [In] byte[] pv,
            uint cbMax,
            [Out] byte[] pvOld,
            uint cbOldMax,
            out uint cbOldActual,
            uint grbit);

        #endregion

        #region Callbacks

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetRegisterCallback(
            IntPtr sesid, IntPtr tableid, uint cbtyp, NATIVE_CALLBACK callback, IntPtr pvContext, out IntPtr pCallbackId);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetUnregisterCallback(IntPtr sesid, IntPtr tableid, uint cbtyp, IntPtr hCallbackId);

        #endregion

        #region Online Maintenance

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDefragment(
            IntPtr sesid, uint dbid, string szTableName, ref uint pcPasses, ref uint pcSeconds, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDefragment(
            IntPtr sesid, uint dbid, string szTableName, IntPtr pcPasses, IntPtr pcSeconds, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDefragment2(
            IntPtr sesid, uint dbid, string szTableName, ref uint pcPasses, ref uint pcSeconds, IntPtr callback, uint grbit);

        [DllImport(EsentDll, CharSet = EsentCharSet, ExactSpelling = true)]
        public static extern int JetDefragment2(
            IntPtr sesid, uint dbid, string szTableName, IntPtr pcPasses, IntPtr pcSeconds, IntPtr callback, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDefragment2W(
            IntPtr sesid, uint dbid, string szTableName, ref uint pcPasses, ref uint pcSeconds, IntPtr callback, uint grbit);

        [DllImport(EsentDll, CharSet = CharSet.Unicode, ExactSpelling = true)]
        public static extern int JetDefragment2W(
            IntPtr sesid, uint dbid, string szTableName, IntPtr pcPasses, IntPtr pcSeconds, IntPtr callback, uint grbit);

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetIdle(IntPtr sesid, uint grbit);
#endif // !MANAGEDESENT_ON_WSA

        #endregion

        #region Misc

#if !MANAGEDESENT_ON_WSA // Not exposed in MSDK
        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetConfigureProcessForCrashDump(uint grbit);

        [DllImport(EsentDll, ExactSpelling = true)]
        public static extern int JetFreeBuffer(IntPtr pbBuf);
#endif // !MANAGEDESENT_ON_WSA

        #endregion
    }
}