<form> <div class=”status-key”>Type here. I will detect when you stop typing</div> <input type=”text” class=”autocomplete”> <div class=”status-ajax”></div> </form> Javascript: $(document).ready(function(){ var $statusKey = $(‘.status-key’); var $statusAjax = $(‘.status-ajax’); var intervalId; // Fake ajax request. Just for demo function make_ajax_request(e){ var that = this; $statusAjax.html(‘That\’s enough waiting. Making now the ajax request’); intervalId = setTimeout(function(){ $statusKey.html(‘Type here. […]
Database versioning (DB Lifecycle Management)
The state-driven approach is good for projects with a lot of logic in the database and a large team working on it. You are also better off choosing it for small projects that are not in production yet. The migration-driven approach is a better choice in all other cases Summary Article: http://enterprisecraftsmanship.com/2015/08/10/database-versioning-best-practices/ State based vs […]
DNVM Dotnet Version Manager DNX and Dotnet Execution Environment
Path = C:\Program Files\Microsoft DNX\DNVM\ On command prompt run: dnvm list This will help initial setup of DNVM. if dnx is not found run: dnvm use default -p The option -p sets up path to dnx permanently in PATH variable. Exclude -p to setup dnx only for the current command prompt session. Purpose and use: EntityFramework […]
SQL Server Cursors – Local, Static, Fast Forward, Read Only
What impact can different cursor options have? Best use – LOCAL FAST_FORWARD than default.
SQL EXCEPT and INTERSECT
— 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.
SQL – UNION
UNION is like a true SET union - where duplicates are removed. UNION ALL keeps duplicated so is not a TRUE set operation.
IISExpress Configuration and Custom Domain setup
Edit File as Administrator: \Documents\IISExpress\config\applicationhost.config Under <sites> <site …> <bindings> <binding protocol=”http” bindingInformation=”*:8080:localhost” /> […]
Avoiding Branching – Use Abstraction to introduce changes
https://continuousdelivery.com/2011/05/make-large-scale-changes-incrementally-with-branch-by-abstraction/#how-branch-by-abstraction-works
Best Entity Framework Reference Concise Tutorial
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 […]
Tutorials Concise Reference
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