public void ParseValidNames()
{
var target = new DbObjectInfo("[some-schema-with-dashes].[uspMyProcedure]");
Assert.Equal("some-schema-with-dashes", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
}
public void ParseTwoPartsFullNames()
{
var target = new DbObjectInfo("[dbo].uspMyProcedure");
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("dbo.[uspMyProcedure]");
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("[dbo].[uspMyProcedure]");
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("[mySchema].uspMyProcedure");
Assert.Equal("mySchema", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("mySchema.[uspMyProcedure]");
Assert.Equal("mySchema", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("[mySchema].[uspMyProcedure]");
Assert.Equal("mySchema", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
}
public void ParseFourPartsFullNames()
{
var target = new DbObjectInfo("[myServer].[myDatabase].[mySchema].[uspMyProcedure]");
Assert.Equal("mySchema", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
}
public void ParseOnePartNames()
{
var target = new DbObjectInfo("uspMyProcedure");
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
target = new DbObjectInfo("[uspMyProcedure]");
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
Assert.Equal("uspMyProcedure", target.Name, StringComparer.Ordinal);
}
public void SetDboSchema()
{
var target = new DbObjectInfo();
Assert.Equal("dbo", target.Schema, StringComparer.Ordinal);
}
