public void ConvertColumndefFromNative()
{
var native = new NATIVE_COLUMNDEF()
{
cbMax = 1,
coltyp = (uint)JET_coltyp.LongText,
columnid = 0x100,
cp = 1200,
grbit = (uint)ColumndefGrbit.ColumnMultiValued,
};
var columndef = new JET_COLUMNDEF();
columndef.SetFromNativeColumndef(native);
Assert.AreEqual(1, columndef.cbMax);
Assert.AreEqual(JET_coltyp.LongText, columndef.coltyp);
Assert.AreEqual <uint>(0x100, columndef.columnid.Value);
Assert.AreEqual(JET_CP.Unicode, columndef.cp);
Assert.AreEqual(ColumndefGrbit.ColumnMultiValued, columndef.grbit);
}
public void ConvertColumndefToNative()
{
var columndef = new JET_COLUMNDEF
{
cbMax = 0x1,
coltyp = JET_coltyp.Binary,
cp = JET_CP.Unicode,
grbit = ColumndefGrbit.ColumnAutoincrement
};
NATIVE_COLUMNDEF native = columndef.GetNativeColumndef();
Assert.AreEqual <uint>(0, native.columnid);
Assert.AreEqual <uint>(9, native.coltyp);
Assert.AreEqual <ushort>(0, native.wCountry);
Assert.AreEqual <ushort>(0, native.langid);
Assert.AreEqual <ushort>(1200, native.cp);
Assert.AreEqual <ushort>(0, native.wCollate);
Assert.AreEqual <uint>(1, native.cbMax);
Assert.AreEqual <uint>(0x10, native.grbit);
}
public void ConvertColumndefToNative()
{
var columndef = new JET_COLUMNDEF
{
cbMax = 0x1,
coltyp = JET_coltyp.Binary,
cp = JET_CP.Unicode,
grbit = ColumndefGrbit.ColumnAutoincrement
};
NATIVE_COLUMNDEF native = columndef.GetNativeColumndef();
Assert.AreEqual <uint>(0, native.columnid);
Assert.AreEqual <uint>(9, native.coltyp);
#pragma warning disable 618,612 // Disable warning that wCountry/langid/wCollate are obsolete
Assert.AreEqual <ushort>(0, native.wCountry);
Assert.AreEqual <ushort>(0, native.langid);
Assert.AreEqual <ushort>(1200, native.cp);
Assert.AreEqual <ushort>(0, native.wCollate);
#pragma warning restore 618,612
Assert.AreEqual <uint>(1, native.cbMax);
Assert.AreEqual <uint>(0x10, native.grbit);
}
public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);
public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, ref uint pcolumnid, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);
public static extern int JetAddColumn(IntPtr sesid, IntPtr tableid, string szColumnName, [In] ref NATIVE_COLUMNDEF columndef, [In] byte[] pvDefault, uint cbDefault, out uint columnid);
public static extern int JetGetColumnInfo(IntPtr sesid, uint dbid, string szTableName, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);
public static extern int JetGetTableColumnInfo(IntPtr sesid, IntPtr tableid, ref uint pcolumnid, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);
public static extern int JetGetTableColumnInfoW(IntPtr sesid, IntPtr tableid, string szColumnName, ref NATIVE_COLUMNDEF columndef, uint cbMax, uint InfoLevel);
