コード例 #1
0
        public void QueryContactsEntityConecction()
        {
            using (var con = new EntityConnection("name=PEF"))
            {
                con.Open();
                EntityCommand cmd = con.CreateCommand();

                cmd.CommandText = "SELECT VALUE c " +
                                  "FROM PEF.Contact AS c " +
                                  "WHERE c.FirstName = 'Robert'";

                Dictionary <int, string> dict = new Dictionary <int, string>();
                using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
                {
                    while (rdr.Read())
                    {
                        int a = rdr.GetInt32(0);
                        var b = rdr.GetString(1);
                        dict.Add(a, b);
                        Console.WriteLine("{0} {1}",
                                          a,
                                          b);
                    }
                }
                Console.Write("Press Enter...");
                Console.ReadLine();
            }
            #endregion
        }
コード例 #2
0
 /// <summary>
 /// ESQL
 /// </summary>
 static void RSQL()
 {
     // 这个就是App.config中的数据库连接串
     using (var con = new EntityConnection("name=SchoolDBEntities"))
     {
         //打开连接
         con.Open();
         //通过连接创建一个命令对象
         EntityCommand cmd = con.CreateCommand();
         //设置要执行的SQL语句或存储过程
         cmd.CommandText = "select value s from SchoolDBEntities.StudentSets as s";
         //定义一个接收字典
         Dictionary <int, string> dic = new Dictionary <int, string>();
         //创建一个reader来进行数据读取
         using (EntityDataReader rd = cmd.ExecuteReader(System.Data.CommandBehavior.SequentialAccess | System.Data.CommandBehavior.CloseConnection))
         {
             while (rd.Read())
             {
                 int    a = rd.GetInt32(0);
                 string b = rd.GetString(1);
                 dic.Add(a, b);
             }
         }
     }
 }
コード例 #3
0
        private static void VerifySortAscAndCountInt(EntityDataReader reader, int expectedCount)
        {
            var count = 0;
            int id    = int.MinValue;

            while (reader.Read())
            {
                var newId = reader.GetInt32(0);
                Assert.True(id <= newId);
                id = newId;
                count++;
            }
            Assert.Equal(count, expectedCount);
        }
コード例 #4
0
ファイル: Program.cs プロジェクト: pbirch16/Repos
        //Querying with Object Services and Entity SQL

        //This doesn't work
        //static void QryOS()
        //{
        //    string sqlString = "SELECT VALUE st FROM SchoolDBEntities.Students " +
        //                        "AS st WHERE st.StudenName == 'Steve'";

        //    IObjectContextAdapter ctx = new
        //     var objctx = (ctx as  new IObjectContextAdapter).ObjectContext;

        //    ObjectQuery<Student> student = objctx.CreateQuery<Student>(sqlString);
        //    Student newStudent = student.First<Student>();
        //}

        static void EntityConnection()
        {
            using (var con = new EntityConnection("name=SchoolDBEntities"))
            {
                con.Open();
                EntityCommand cmd = con.CreateCommand();
                cmd.CommandText = "SELECT VALUE st FROM SchoolDBEntities.Students as st where st.StudentName='Steve'";
                Dictionary <int, string> dict = new Dictionary <int, string>();
                using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
                {
                    while (rdr.Read())
                    {
                        int a = rdr.GetInt32(0);
                        var b = rdr.GetString(1);
                        dict.Add(a, b);
                    }
                }
            }
        }
コード例 #5
0
        /// <summary>
        /// EntityDataReader
        /// </summary>
        /// <returns></returns>
        public Dictionary <int, string> GetAllCityByEntityDataReader()
        {
            using (var con = new EntityConnection("name=ManagerSiContext")) {
                con.Open();
                EntityCommand cmd = con.CreateCommand();
                cmd.CommandText = "SELECT VALUE st FROM ManagerSiContext.BASE_CITY as st WHERE st.STATE == '1'";
                Dictionary <int, string> dict = new Dictionary <int, string>();

                using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection)) {
                    while (rdr.Read())
                    {
                        int a = rdr.GetInt32(0);
                        var b = rdr.GetString(1);
                        dict.Add(a, b);
                    }
                }
                return(dict);
            }
        }
コード例 #6
0
        public static void EntitySQLUsingEntityConnectionDemo()
        {
            Console.WriteLine("*** EntitySQLUsingEntityConnectionDemo Start ***");
            using (var con = new EntityConnection("name=SchoolDBEntities"))
            {
                con.Open();
                EntityCommand cmd = con.CreateCommand();
                cmd.CommandText = "SELECT VALUE st FROM SchoolDBEntities.Students as st where st.StudentID = 1";
                Dictionary <int, string> dict = new Dictionary <int, string>();
                using (EntityDataReader rdr = cmd.ExecuteReader(CommandBehavior.SequentialAccess | CommandBehavior.CloseConnection))
                {
                    while (rdr.Read())
                    {
                        int a = rdr.GetInt32(0);
                        var b = rdr.GetString(1);

                        dict.Add(a, b);
                    }
                }
            }

            Console.WriteLine("*** EntitySQLUsingEntityConnectionDemo Finished ***");
        }