private static void ExecuteUpdate(ISession session, string sql, object[][] dataTable)
{
for (int i = 0; i < dataTable.GetLength(0); i++)
{
IQuery query = session.CreateSQLQuery(sql);
for (int j = 0; j < dataTable[i].GetLength(0); j++)
{
object objValue = dataTable[i][j];
if (objValue == null)
{
//Workaround: cant set NULL value for int type
query.SetBinary(j, null);
}
else
{
query.SetParameter(j, objValue);
}
}
query.ExecuteUpdate();
}
}