EF C# 实例

 

1: New

using (aipEntitiesSmartFeeder smartFeederEntities = new aipEntitiesSmartFeeder())
{
    setup_list _setupList = new setup_list();
    _setupList .mc_id = 1;
    _setupList.stage = 2;
    smartFeederEntities.setup_list.Add(_setupList);
    smartFeederEntities.SaveChanges();
}

2: Update

using (aipEntitiesSmartFeeder smartFeederEntities = new aipEntitiesSmartFeeder())
{
    setup_list _setupList = new setup_list();
    _setupList .mc_id = 1;
    _setupList.stage = 2;
    smartFeederEntities.Entry(_setupList).State = EntityState.Modified;
    smartFeederEntities.SaveChanges();
}

3:Delete

using (aipEntitiesSmartFeeder smartFeederEntities = new aipEntitiesSmartFeeder())
{
    setup_list _setupList = new setup_list();
    _setupList.mc_id = 1;
    _setupList.stage = 2;
    smartFeederEntities.Attach(_setupList);
    smartFeederEntities.Remove(_setupList);
    smartFeederEntities.SaveChanges();
}

4:Select

using (aipEntitiesSmartFeeder smartFeederEntities = new aipEntitiesSmartFeeder())
{

    var expr = from p in smartFeederEntities._setupList
                select p;
    foreach (var item in expr)
    {
        Console.WriteLine("{0}-{1}-{2}", item.mc_id , item.ProvinceNo, item.stage );
    }
}


using (aipEntitiesSmartFeeder smartFeederEntities = new aipEntitiesSmartFeeder())
{
    //根据TSQL查询
    DbSqlQuery<setup_list> dbSqlQuery = smartFeederEntities.setup_list.SqlQuery("select * from [setup_list] where [ID] = {0}", 2);

}