public void CreatesWellFormedInsert()
{
var properties = new Dictionary <string, EntityProperty>();
properties.Add("@name", _nameProperty);
var sql = _queryGenerator.Insert(Table, properties, _idProperty);
var expectedSql = "set nocount on insert into [TestClasses] (Name) values (@name) select SCOPE_IDENTITY()";
Assert.Equal(expectedSql, sql);
}
public void CreatesWellFormedInsert()
{
var properties = new Dictionary <string, EntityProperty>();
properties.Add("@id", _idProperty);
var sql = _queryGenerator.Insert(Table, properties, _idProperty);
var expectedSql = "insert into [NonIdentityKeyClasses] (Id) values (@id)";
Assert.Equal(expectedSql, sql);
}
public void CreatesWellFormedInsert()
{
var properties = new Dictionary <string, EntityProperty>();
properties.Add("@name", _nameProperty);
properties.Add("@description", _descriptionProperty);
var sql = _queryGenerator.Insert(Table, properties, _idProperty);
var expectedSql = "set nocount on insert into [AliasedColumnsClasses] (ADifferentName, Description) values (@name, @description) select SCOPE_IDENTITY()";
Assert.Equal(expectedSql, sql);
}