| private Into ( IObjectInfo objectInfo ) : IInsertColumn | ||
| objectInfo | IObjectInfo | |
| return | IInsertColumn | |
public void InsertIntoSpecifyingTableName()
{
var sqlBuilder = new InsertSqlBuilder(SqlCharacters.Empty);
var sqlQuery = sqlBuilder
.Into("Table")
.ToSqlQuery();
Assert.Equal("INSERT INTO Table", sqlQuery.CommandText);
Assert.Empty(sqlQuery.Arguments);
}
public void InsertIntoSpecifyingType()
{
var sqlBuilder = new InsertSqlBuilder(SqlCharacters.Empty);
var sqlQuery = sqlBuilder
.Into(typeof(Customer))
.ToSqlQuery();
Assert.Equal("INSERT INTO Sales.Customers", sqlQuery.CommandText);
Assert.Empty(sqlQuery.Arguments);
}
public void InsertIntoColumnsValuesWithSqlCharacters()
{
var sqlBuilder = new InsertSqlBuilder(MsSqlCharacters.Instance);
var sqlQuery = sqlBuilder
.Into("Table")
.Columns("Column1", "Column2")
.Values("Foo", 12)
.ToSqlQuery();
Assert.Equal("INSERT INTO [Table] ([Column1],[Column2]) VALUES (@p0,@p1)", sqlQuery.CommandText);
Assert.Equal(2, sqlQuery.Arguments.Count);
Assert.Equal("Foo", sqlQuery.Arguments[0]);
Assert.Equal(12, sqlQuery.Arguments[1]);
}
public void InsertIntoColumnsValues()
{
var sqlBuilder = new InsertSqlBuilder(SqlCharacters.Empty);
var sqlQuery = sqlBuilder
.Into("Table")
.Columns("Column1", "Column2")
.Values("Foo", 12)
.ToSqlQuery();
Assert.Equal("INSERT INTO Table (Column1,Column2) VALUES (?,?)", sqlQuery.CommandText);
Assert.Equal(2, sqlQuery.Arguments.Count);
Assert.Equal("Foo", sqlQuery.Arguments[0]);
Assert.Equal(12, sqlQuery.Arguments[1]);
}
public void InsertIntoSpecifyingTypeWithSqlCharacters()
{
var sqlBuilder = new InsertSqlBuilder(MsSqlCharacters.Instance);
var sqlQuery = sqlBuilder
.Into(typeof(Customer))
.ToSqlQuery();
Assert.Equal("INSERT INTO [Sales].[Customers]", sqlQuery.CommandText);
Assert.Empty(sqlQuery.Arguments);
}