public void schemaUpdateMultipleSessions()
{
Assert.Throws <OptimisticLockingFailed>(() =>
{
using (ServerClientSession session = new ServerClientSession(systemDir))
{
session.BeginUpdate();
Placement place = new Placement(555, 1, 1, 10, 10);
Simple1 s1 = new Simple1(1);
s1.Persist(place, session);
s1 = null;
using (ServerClientSession session2 = new ServerClientSession(systemDir))
{
Placement place2 = new Placement(556, 1, 1, 10, 10);
session2.BeginUpdate();
Simple2 s2 = new Simple2(2);
s2.Persist(place2, session2);
s2 = null;
session.Commit();
session2.Commit(); // optemistic locking will fail due to session2 working with a stale schema (not the one updated by session 1)
session.BeginUpdate();
s1 = (Simple1)session.Open(555, 1, 1, false);
s2 = (Simple2)session.Open(556, 1, 1, false);
session.Commit();
session2.BeginUpdate();
s1 = (Simple1)session2.Open(555, 1, 1, false);
s2 = (Simple2)session2.Open(556, 1, 1, false);
session2.Commit();
}
}
});
}
public void SimpleTest()
{
Simple1 s = Mapper.Map <Simple2, Simple1>(new Simple2());
Assert.AreEqual(20, s.I);
Assert.AreEqual(A.En.En2, s.fld1);
}
/// <summary>
/// Here we get the sheet names for all sheets in the file Sample1.xlsx and as delievered,
/// I placed the Sheet names out of order so they will show up in the ListBox in the ordinal
/// position in the workbook. If we used OleDb to get sheet names OleDb will sort them a-z.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmdGetSheets_Click(object sender, EventArgs e)
{
lstSheetNames.DataSource = null;
Simple1 Demo = new Simple1();
List <string> Names = Demo.GetSheetNames(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Sample1.xlsx"));
lstSheetNames.DataSource = Names;
}
public void SimpleTest()
{
var mapper = ObjectMapperManager.DefaultInstance.GetMapper <Simple2, Simple1>();
//DynamicAssemblyManager.SaveAssembly();
Simple1 s = mapper.Map(new Simple2());
Assert.AreEqual(20, s.I);
Assert.AreEqual(A.En.En2, s.fld1);
}
public IActionResult Index()
{
Simple1 s = new Simple1();
SqlConnectionStringBuilder _sqlConnectorStr = new SqlConnectionStringBuilder();
SqlConnection _Conn;
SqlCommand command;
SqlDataReader dr;
s._Age = 037;
s._Name = "Souffle";
_sqlConnectorStr["Data Source"] = "(local)";
_sqlConnectorStr["integrated Security"] = true;
_sqlConnectorStr["Initial Catalog"] = "AdventureWorks2017";
_sqlConnectorStr.UserID = "sa";
_sqlConnectorStr.Password = "";
//_sqlConnectorStr["UserID"] = "sa";
//_sqlConnectorStr["Password"] = "";
try
{
_Conn = new SqlConnection(_sqlConnectorStr.ConnectionString);
_Conn.Open();
command = new SqlCommand("select Name from Production.Location ", _Conn);
dr = command.ExecuteReader();
while (dr.Read())
{
s.values.Add(dr["name"].ToString());
}
_Conn.Close();
}
catch (Exception)
{
s.values.Add("No values");
}
finally
{
//Do nothing
}
return(View(s));
}
private void cmdSimpleOpenToSheet_Click(object sender, EventArgs e)
{
Simple1 Demo = new Simple1();
Demo.OpenExcel(System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Sample1.xlsx"), "Sheet1");
}
