EntityFramework相關技巧

直接下SQL

範例說明：https://msdn.microsoft.com/en-us/library/jj592907\(v=vs.113\).aspx

using (var ctx = new MyDbContext())
{
    var peopleViews = ctx.SqlQuery<PersonView>("SELECT PersonID, Name FROM Person").ToList();
}

public class PersonView
{
    public int PersonID { get; set; }
    public string Name { get; set; }
}

rewrite connection string

public partial class OrchestratorUserStateEntities
    {
        public OrchestratorUserStateEntities(string connStr)
            : base(string.Format(@"metadata=res://*/;provider=System.Data.SqlClient;provider connection string='{0}'", connStr))
        {

        }
    }