SqlServer的锁和EntityFramework调用存储过程

Question

sqlserver里有行锁，表锁
with(rowlock)

Answer 1

http://www.cnblogs.com/CareySon/archive/2012/03/22/2411292.html

Answer 2

 public List<News> GetNewsByTags(string tags)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("exec GetAllSearchNewsByTags @tags,@status");
            int status = PortalEnum.NewsStatus.Published.GetHashCode();
            SqlParameter[] parameters =
                {
                    new SqlParameter("@tags", SqlDbType.NVarChar),
                    new SqlParameter("@status", SqlDbType.Int),
                };
            parameters[0].Value = tags;
            parameters[1].Value = status;
            IEnumerable<News> iEnumerable = context.Database.SqlQuery<News>(strSql.ToString(), parameters);
            List<News> list = iEnumerable.ToList<News>();
            return list.Distinct().OrderByDescending(p => p.CreateTime).ToList();
        }
这样不就可以了，返回list