Author: p k

— AdventureWorks DB SELECT ProductID FROM Production.Product INTERSECT SELECT ProductID FROM Production.WorkOrder ; ==== Gives ONLY matching ProductIDs.. SELECT ProductID FROM Production.Product EXCEPT SELECT ProductID FROM Production.WorkOrder ; –Result: 266 Rows (products without work orders) ==== Gives ProductIDs from Left Set which are NOT in the right Set.

UNION is like a true SET union ​- where duplicates are removed. UNION ALL keeps duplicated so is not a TRUE set operation.

Edit File as Administrator:  \​Documents\IISExpress\config\applicationhost.config Under <sites>                  <site …>                      <bindings>                           <binding protocol=”http” bindingInformation=”*:8080:localhost” />                         […]

​​https://continuousdelivery.com/2011/05/make-large-scale-changes-incrementally-with-branch-by-abstraction/#how-branch-by-abstraction-works​

EF6  ​http://www.entityframeworktutorial.net/entityframework6/introduction.aspx EF5 http://www.entityframeworktutorial.net/EntityFramework5/entity-framework5-introduction.aspx​ EF Version History and Features links https://msdn.microsoft.com/en-us/data/jj574253.aspx​ EF querying approaches: http://www.entityframeworktutorial.net/Querying-with-EDM.aspx ## LINQ to Entities: context.Students.where(s => s.StudentName == “Bill”) ## Entity SQL: string sqlString = “SELECT VALUE st FROM SchoolDBEntities.Students ” +                     “AS st WHERE st.StudentName == ‘Bill’”; var objctx […]

http://www.tutorialsteacher.com/csharp/csharp-tutorials or DotnetPerls​ or SitePoint OR http://www.tutorialspoint.com/asp.net/asp.net_life_cycle.htm OR YOUTUBE Execute C# online https://www.tutorialspoint.com/csharp/index.htm JSFiddle for execute JS, HTML, CSS online  

DBEntityEntry enables you to access entity state, current, and original values of all the property of a given entity.​ ​DBEntityEntry studentEntry = dbcontext.Entry(StudentEntity); studentEntry.Reload(); // reload entity from DB, discard in-memory changes.. Or mark an entry as modified manually – (ready to update db on save) studentEntry.State = ​System.Data.Entity.EntityState.Modified​; ​​​EF Change Tracking (CT): ## How many entries are […]

New Features in C# 7.0 ​Very good but lengthy article. But with examples, hence simple. C# 6.0 Language features New Features in C# 6 c# 5.0 features https://blogs.msdn.microsoft.com/mvpawardprogram/2012/03/26/an-introduction-to-new-features-in-c-5-0/​

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!