public void NullQueryOrStoredProc_Throws_ArgumentNullException()
{
var sqlDataAccessor = new SqlDataAccessor(ConfigurationManager.AppSettings["DBConnection"]);
Action act = () => sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <object>(null);
act.ShouldThrow <ArgumentNullException>();
}
/// <summary>
/// Create new general data accessor
/// </summary>
/// <param name="conn">
/// Connection object
/// </param>
/// <param name="t">
/// Type of IModel object.
/// </param>
/// <param name="trans">
/// Transaction object
/// </param>
/// <returns>
/// IData accessors object
/// </returns>
public IDataAccessor CreateAccessor(IDbConnection conn, Type t, IDbTransaction trans)
{
IDataAccessor accessor = new SqlDataAccessor(conn, t, trans);
return(accessor);
//return null;
}
public ActionResult About()
{
ViewBag.Message = "Bob";
var sqlConnector = new SqlDataAccessor();
var months = sqlConnector.GetSingleMonthInfo(2, 2017);
return(View(months));
}
private void mjTextBox1_Click(object sender, EventArgs e)
{
// IDataAccessor da = DataAccessorFactory.Instance.GetDataAccessor(DataAccessorFactory.AccessorType.SqlServer);
IDataAccessor da = new SqlDataAccessor();
test2 t = new test2();//任何实体都可以
//t.name = rnd.Next().ToString() + i.ToString();
da.InsertEntity(t);
}
public void SqlDataAccessor_ReturnsExpectedCollection_From_Database()
{
var connectionString = ConfigurationManager.AppSettings["DBConnection"];
var sqlDataAccessor = new SqlDataAccessor(connectionString);
List <Employee> employeesList = sqlDataAccessor.RetrieveDomainObjectCollectionFromDatabase <Employee>("dbo.GetAllEmployees").ToList();
employeesList
.Should()
.NotBeEmpty()
.And.HaveCount(4)
.And.ContainItemsAssignableTo <Employee>();
}
public void SqlDataAccessor_Returns_ExpectedSingleObject_From_Database()
{
var connectionString = ConfigurationManager.AppSettings["DBConnection"];
var sqlDataAccessor = new SqlDataAccessor(connectionString);
Employee employee = sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <Employee>(
"dbo.GetAllEmployeeWithId",
new Dictionary <string, object>()
{
{ "@Id", "EMP1" }
});
employee.Should().NotBeNull("because we know the employee exists");
}
[Ignore] // Does not work yet
public void SqlDataAccessor_Returns_ExpectedSingleObject_From_Database_WithTextCommand()
{
var connectionString = ConfigurationManager.AppSettings["DBConnection"];
var sqlDataAccessor = new SqlDataAccessor(connectionString);
Employee employee = sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <Employee>(
"SELECT EmployeeId, FirstName ,LastName ,DateOfJoining FROM dbo.Employees WHERE EmployeeId = @Id AND FirstName = @FName",
new Dictionary <string, object>()
{
{ "@Id", "EMP1" },
{ "@FName", "John" }
});
employee.Should().NotBeNull("because we know the employee exists");
}
