public void AddNewTest()
{
using (System.Data.Entity.Core.EntityClient.EntityConnection entity = new System.Data.Entity.Core.EntityClient.EntityConnection("MyProjectEF1"))
{
entity.Open();
EntityCommand cmd = entity.CreateCommand();
cmd.CommandText = @"select doubt d from uLibrary as d where d.";
}
MyProjectEF mp = new MyProjectEF();
mp.uLibrary.ToList();
mp.uUsers.Add(new uUser()
{
UserName = "******",
Password = Base64Helper.Base64Encode("msc@123321"),
Email = "*****@*****.**",
CreationDate = DateTime.Now,
EditDate = DateTime.Now,
FirstName = "Edwin",
LastName = "Nie",
FullName = "Edwin Nie",
LCV = false
});
mp.SaveChanges();
}
private void ejemploentity() {
using (EntityConnection conn = new EntityConnection("name=travelEntitiesGeneral"))
{
conn.Open();
EntityCommand cmd = conn.CreateCommand();
cmd.CommandText = @"select c.BlogID from travelEntitiesGeneral.Blogs as c where c.BlogPosts.Count > 0";
EntityDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (reader.Read())
{
Console.WriteLine("BlogID = {0}", reader["BlogID"]);
}
conn.Close();
}
}
static void Main(string[] args)
{
string city = "London";
using (EntityConnection cn = new EntityConnection("Name=Entities"))
{
cn.Open();
EntityCommand cmd = cn.CreateCommand();
cmd.CommandText = @"SELECT VALUE c FROM Entities.Customers AS c WHERE
c.Address.City = @city";
cmd.Parameters.AddWithValue("city", city);
DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
while (rdr.Read())
Console.WriteLine(rdr["CompanyName"].ToString());
rdr.Close();
}
}
public void When_Same_Primary_Key_Name_Is_Used_For_Two_Tables_Correct_Number_Of_MetaData_Rows_Is_Returned()
{
this.CreateIfNotExists();
var workspace = CreateMetadataWorkspace();
var connection = new EntityConnection(workspace, new SqlCeConnection(dbConnectionString));
connection.Open();
var command = connection.CreateCommand();
command.CommandText = TableDetailSql;
var rowCount = 0;
using (var reader = command.ExecuteReader(CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
rowCount++;
}
}
Assert.Equal(4, rowCount);
}
public ActionResult EntitySQL(int id = 0)
{
string esqlQuery = @"SELECT VALUE customers FROM AdventureWorksEntities.Customers AS customers WHERE customers.CustomerID == @id";
var customers = new List<Customer2>();
using(var conn = new EntityConnection("name=AdventureWorksEntities"))
{
conn.Open();
using(var cmd = conn.CreateCommand())
{
cmd.CommandText = esqlQuery;
var param = new EntityParameter {
ParameterName = "id",
Value = id
};
cmd.Parameters.Add(param);
using(var reader = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess))
{
while (reader.Read())
{
var customer = new Customer2
{
CustomerID = int.Parse(reader["CustomerID"].ToString()),
CustomerName = reader["FirstName"] + " " + reader["MiddleName"] + " " + reader["LastName"]
};
customers.Add(customer);
}
}
}
conn.Close();
}
return View(customers);
}
private static void FunWithEntityDataReader() {
using (EntityConnection cn = new EntityConnection("name=AutoLotEntities")) {
cn.Open();
string queryString = "SELECT VALUE car from AutoLotEntities.Cars as car WHERE car.Color='Black'";
using (EntityCommand cmd = cn.CreateCommand()) {
cmd.CommandText = queryString;
using (EntityDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess)) {
while (dr.Read()) {
Console.WriteLine(dr["CarID"]);
}
}
}
}
}
