public DataModificationResult DeletePerson(Person person)
{
try
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
db.Person.Attach(person);
db.Person.Remove(person);
db.SaveChanges();
return new DataModificationResult() { Result = DataModificationResult.Results.Ok };
}
}
catch (DbUpdateConcurrencyException ex)
{
return new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
};
}
catch (Exception ex)
{
return new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
};
}
}
/// <summary>
/// Original solution by EF (data binding costs from client around 9000ms)
/// </summary>
/// <returns></returns>
public List<Person> GetPersons()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
return db.Person.ToList();
}
}
public DataModificationResult UpdatePerson(Person person)
{
try
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
db.Person.Attach(person);
db.Entry(person).State = EntityState.Modified;
db.SaveChanges();
return(new DataModificationResult()
{
Result = DataModificationResult.Results.Ok
});
}
}
catch (DbUpdateConcurrencyException ex)
{
return(new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
});
}
catch (Exception ex)
{
return(new DataModificationResult()
{
Result = DataModificationResult.Results.OptimisticConcurrencyException,
ExceptionMessage = ex.Message
});
}
}
/// <summary>
/// Original solution by EF (data binding costs from client around 9000ms)
/// </summary>
/// <returns></returns>
public List <Person> GetPersons()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
return(db.Person.ToList());
}
}
public void BulkInsert10000Records()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
List<Person> data = new List<Person>();
Random rnd = new Random();
Guid guid;
for(int i = 0; i<=10000;i++)
{
guid = Guid.NewGuid();
data.Add(new Person { FirstName = guid.ToString().Substring(0, 8), LastName = guid.ToString().Substring(9, 8), BirthDate = DateTime.Now.AddDays(-rnd.Next(1, 10000)) });
}
db.BulkInsert<Person>(data);
db.SaveChanges();
}
}
public void BulkInsert10000Records()
{
using (PraetorTestEntities db = new PraetorTestEntities())
{
List <Person> data = new List <Person>();
Random rnd = new Random();
Guid guid;
for (int i = 0; i <= 10000; i++)
{
guid = Guid.NewGuid();
data.Add(new Person {
FirstName = guid.ToString().Substring(0, 8), LastName = guid.ToString().Substring(9, 8), BirthDate = DateTime.Now.AddDays(-rnd.Next(1, 10000))
});
}
db.BulkInsert <Person>(data);
db.SaveChanges();
}
}
/// <summary>
/// Solution using SqlDataReader much faster (data binding costs from client around 3000ms)
/// </summary>
/// <returns></returns>
public List <Person> GetPersonsDS()
{
List <Person> retval = new List <Person>();
SqlConnection connection = new SqlConnection();
using (PraetorTestEntities db = new PraetorTestEntities())
{
connection.ConnectionString = db.Database.Connection.ConnectionString;
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM dbo.Person";
cmd.Connection = connection;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
#warning ToDo: Create universal void for filling EF object from reader (Get properties names and datatypes by reflection)
retval.Add(
new Person()
{
Id = Convert.ToInt32(reader["Id"]),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
BirthDate = Convert.ToDateTime(reader["BirthDate"]),
RowVersion = (byte[])reader["RowVersion"]
});
}
}
reader.Close();
connection.Close();
return(retval);
}
/// <summary>
/// Solution using SqlDataReader much faster (data binding costs from client around 3000ms)
/// </summary>
/// <returns></returns>
public List<Person> GetPersonsDS()
{
List<Person> retval = new List<Person>();
SqlConnection connection = new SqlConnection();
using (PraetorTestEntities db = new PraetorTestEntities())
{
connection.ConnectionString = db.Database.Connection.ConnectionString;
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "SELECT * FROM dbo.Person";
cmd.Connection = connection;
connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
#warning ToDo: Create universal void for filling EF object from reader (Get properties names and datatypes by reflection)
retval.Add(
new Person()
{
Id = Convert.ToInt32(reader["Id"]),
FirstName = reader["FirstName"].ToString(),
LastName = reader["LastName"].ToString(),
BirthDate = Convert.ToDateTime(reader["BirthDate"]),
RowVersion = (byte[])reader["RowVersion"]
});
}
}
reader.Close();
connection.Close();
return retval;
}