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); }