public void Insert_Simple()
{
Insert i = new Insert().Into(Category.Schema).Values("Test", "TestDescription", DBNull.Value);
string sql = i.BuildSqlStatement();
Assert.IsTrue(sql == "INSERT INTO [dbo].[Categories](CategoryName,Description,Picture)\r\n VALUES (@ins_CategoryName,@ins_Description,@ins_Picture)\r\n");
}
public void Acc_Insert_Simple()
{
Insert i = new Insert().Into(Category.Schema).Values("Test", "TestDescription", DBNull.Value);
string sql = i.BuildSqlStatement();
Assert.AreEqual(sql, "INSERT INTO [Categories](CategoryName,Description,Picture)\r\n VALUES ([PARM__ins_CategoryName],[PARM__ins_Description],[PARM__ins_Picture])\r\n");
}
public void Acc_Insert_SimpleWithSelect()
{
Insert i = new Insert().Into(Category.Schema)
.Select(new Select("CategoryName", "Description", "Picture").From(Category.Schema));
string sql = i.BuildSqlStatement();
Assert.IsTrue(sql ==
"INSERT INTO [Categories](CategoryName,Description,Picture)\r\nSELECT [Categories].[CategoryName], [Categories].[Description], [Categories].[Picture]\r\n FROM [Categories]\r\n\r\n");
}
public void Insert_SimpleWithSelect()
{
Insert i = new Insert().Into(Category.Schema)
.Select(new Select("CategoryName", "Description", "Picture").From(Category.Schema));
string sql = i.BuildSqlStatement();
Assert.IsTrue(sql ==
"INSERT INTO [dbo].[Categories](CategoryName,Description,Picture)\r\nSELECT [dbo].[Categories].[CategoryName], [dbo].[Categories].[Description], [dbo].[Categories].[Picture]\r\n FROM [dbo].[Categories]\r\n\r\n");
}
public void Insert_SimpleWithSelectAndSchema()
{
Insert i = new Insert().Into(Category.Schema)
.Select(Select.AllColumnsFrom <Category>());
string sql = i.BuildSqlStatement();
Assert.AreEqual(
"INSERT INTO [dbo].[Categories](CategoryName,Description,Picture)\r\nSELECT [dbo].[Categories].[CategoryName], [dbo].[Categories].[Description], [dbo].[Categories].[Picture]\r\n FROM [dbo].[Categories]\r\n\r\n",
sql);
}
public void Acc_Insert_SimpleWithSelectAndSchema()
{
Insert i = new Insert().Into(Category.Schema)
.Select(Select.AllColumnsFrom<Category>());
string sql = i.BuildSqlStatement();
Assert.AreEqual(
"INSERT INTO [Categories](CategoryName,Description,Picture)\r\nSELECT [Categories].[CategoryName], [Categories].[Description], [Categories].[Picture]\r\n FROM [Categories]\r\n\r\n",
sql);
}
public void Acc_Insert_Simple()
{
Insert i = new Insert().Into(Category.Schema).Values("Test", "TestDescription", DBNull.Value);
string sql = i.BuildSqlStatement();
Assert.AreEqual(sql, "INSERT INTO [Categories](CategoryName,Description,Picture)\r\n VALUES ([PARM__ins_CategoryName],[PARM__ins_Description],[PARM__ins_Picture])\r\n");
}
public void Insert_Simple()
{
Insert i = new Insert().Into(Category.Schema).Values("Test", "TestDescription", DBNull.Value);
string sql = i.BuildSqlStatement();
Assert.IsTrue(sql == "INSERT INTO [dbo].[Categories](CategoryName,Description,Picture)\r\n VALUES (@ins_CategoryName,@ins_Description,@ins_Picture)\r\n");
}
