net Entity Framework 学习笔记

简单读取数据过程。实际未测试。

引用的namespace

using System.Data.Objects;

using System.ComponentModel.DataAnnotations.Schema;
using System.ComponentModel.DataAnnotations;

/// <summary>

    /// 实体定义
    /// </summary>
    [Table("user")]
    public class UserInfo
    {
        [Key]
        [Column("userId")]
        public int userId { set; get; }
        [Column("userName")]
        public String userName { set; get; }
    }
    /// <summary>
    /// 数据集绑定到数据集
    /// </summary>
    public class UserInfoEntites : ObjectContext
    {
        public UserInfoEntites()
            : base("name=ConnectString")
        {
            
        }
        public ObjectSet<UserInfo> userInfo { get; set; }
    }
    /// <summary>
    /// DaoImp中执行取数据操作
    /// </summary>
    public class TestAction{
        public static void testdo(){
            UserInfoEntites db = new UserInfoEntites();
            ObjectQuery<UserInfo> query =  db.CreateQuery<UserInfo>("", new ObjectParameter[] {new ObjectParameter("","") });
            
            Console.WriteLine( query.First().userId);
            int n = query.Count<UserInfo>();
            UserInfo t = query.ElementAt(0);
           
        }
    }