• EF 学习代码


    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Text;
    using DB.Model;
    using System.Data;
    using System.Data.Objects;
    using System.Data.EntityClient;
    using System.Web;

    namespace Test
    {
    class Program
    {
    static void Main(string[] args)
    {
    //using (DB.Model.pubsEntities pubs = new DB.Model.pubsEntities())
    //{}
    #region 增加
    /*
    DB.Model.Test test = new DB.Model.Test();
    test.Name = "张三";
    pubs.AddToTest(test);
    pubs.SaveChanges();
    Console.WriteLine(pubs.Test.ToTraceString());
    */
    #endregion

    #region 分页查询
    /*
    IList<DB.Model.Test> testList = pubs.Test.OrderByDescending(p=>p.ID).Skip(10).Take(10).ToList();
    foreach (DB.Model.Test val in testList)
    {
    Console.WriteLine(val.Name);
    }
    */
    #endregion

    #region 聚合
    // Console.WriteLine(pubs.Test.Max(p => p.ID));
    #endregion

    #region 多表连接
    /*
    var result = pubs.authors.Join(pubs.titleauthor, p => p.au_id, p => p.au_id, (p, k) => new { Authors = p, titleauthor = k })
    .Take(10)
    .ToList();
    foreach (var s in result)
    {
    Console.WriteLine("id:{0},c:{1}", s.Authors.au_id, s.titleauthor);
    }
    */
    #endregion

    #region 删除
    /*
    pubs.Test.DeleteObject(pubs.Test.Where(p => p.ID == 106939).First());
    pubs.SaveChanges();
    */
    #endregion

    #region 修改
    /*
    DB.Model.Test test = pubs.Test.Where(p => p.ID == 106938).First();
    test.Name = "TESTEST";
    pubs.SaveChanges();
    */
    #endregion

    #region ESql
    //ESql
    //string strESql = "select value tit from pubsEntities.titles as tit";
    //string strESql = "select value tit from pubsEntities.Test as tit where tit.id=@id";
    //// string strESql = "select value key(tit) from pubsEntities.Test as tit order by tit.ID desc limit 20";
    // string strEsql = "select value tit from pubsEntities.Test as tit where tit.id=-1";
    // var result = pubs.CreateQuery<DB.Model.Test>(strEsql).FirstOrDefault();

    //foreach (var val in result)
    //{
    // Console.WriteLine(val);
    //}

    //Console.WriteLine(pubs.Test.ToTraceString());
    //System.Diagnostics.Debug.Assert(null != result, "First结果为NULL");
    ////Console.WriteLine(result.ID);
    //string str1 = "select value tit from pubsEntities.Test as tit order by tit.id desc limit 10";
    //string str2 = "select value tit from pubsEntities.Test as tit order by tit.id desc limit 20";
    //var result = pubs.CreateQuery<DB.Model.Test>(str1).Intersect(pubs.CreateQuery<DB.Model.Test>(str2));
    //System.Diagnostics.Debug.Assert(null != result, "差集为NUll");
    //foreach (var r in result)
    //{
    // Console.WriteLine(r.ID);
    //}
    //Console.WriteLine(pubs.Test.ToTraceString());
    #endregion

    #region EntityClient
    //l EntityConnection
    //l EntityCommand
    //l EntityConnectionStringBuilder
    //l EntityParameter
    //l EntityDataReader
    //l EntityParameterCollection
    //l EntityProviderFactory
    //l EntityTransaction
    DB.Model.pubsEntities pubs = new pubsEntities();
    using (EntityConnection con = new EntityConnection(pubs.Connection.ConnectionString))
    {
    //Console.WriteLine(pubs.Connection.ConnectionString);
    //string strSql = "select value tit from pubsEntities.Test as tit order by tit.id desc limit 20";
    con.Open();
    //EntityCommand cmd = new EntityCommand(strSql, con);
    //var result = cmd.ExecuteReader(CommandBehavior.SequentialAccess);
    //while (result.Read())
    //{
    // Console.WriteLine(result[0]);
    //}
    //con.Close();

    //var resultList = pubs.GetTestDataTop(MergeOption.NoTracking);
    //foreach (var val in resultList)
    //{
    // Console.WriteLine(val.ID);
    //}
    //EntityKey key = new EntityKey("pubsEntities.Test", "Test.id", 1000);
    //Console.WriteLine((pubs.GetObjectByKey(key) as DB.Model.Test).ID);

    var exec
    = CompiledQuery.Compile<pubsEntities, IEnumerable<DB.Model.Test>>(p => p.Test.Where(k => k.ID >3000));
    foreach (var s in exec(pubs))
    {
    Console.WriteLine(s.ID);
    }

    pubs.Refresh(RefreshMode.ClientWins, model);
    //并发处理方法
    }

    #endregion
    }
    }
    }
    学习地址 http://www.cnblogs.com/xray2005/archive/2009/05/07/1452033.html 
  • 相关阅读:
    oracle--函数
    分页查询
    行列转置(Oracle)
    手动安装Oracle的Maven依赖
    Windows下安装Oracle拖慢开机速度的解决方法
    kettle将Excel数据导入oracle
    Oracle交易流水号问题
    在32位Centos6.4上安装GraphicsMagick
    Centos版本 32或64位查看命令
    Nginx指令概述
  • 原文地址:https://www.cnblogs.com/blackman/p/2055472.html
Copyright © 2020-2023  润新知