Thursday, January 29, 2015

How popular is JavaScript?

It has gained lot of popularity because of the many libraries developed succh as jQuery, Bootstrap, Node.JS, win.JS, dogo etc. Toagether with HTML5 it has become all the more popular for web development.

The popularity of a programming language is described by an inex called the TIOBE Index.
TIOBE index provides a measure for the popularity of programming languages as mined from search engines. It includes many browser results as well as many programming languages. The index is published every month and for the month of January you can find it here:
http://www.tiobe.com/index.php/content/paperinfo/tpci/index.html

Programming languages C and Java are the top dogs and Javascript jumped from 9 to 7 in January 2015 and C# steady from 2014 to 2015 at 5.

TIOBE Index is calculated by the query +"Language> programming" to the search engines.

Get more info on TIOBE herre:
http://www.tiobe.com/index.php/content/products/tics/TICS_framework.html

 

Tuesday, January 27, 2015

Where do I find the C# Compiler on my computer?


The C# compiler CSC.exe is found here:
  C:\Windows\Microsoft.NET\Framework\v4.0.30319\Csc.exe

This is on a Windows 8.1 Professional machine.

In any case search in this folder by changing the directory as shown below
C:/ cd %Windir%/Microsoft.NET/Framework

You may find more than one Framework on your computer
The one shown in the beginning of this post is for version 4.0.30319

Monday, January 26, 2015

Can I work on Stored Procedures using LinqPad?

Of course you can. In version4.51.03 you can easily run stored procedures you have created using both SQL and C# Expression.

For example, after connecting to AdvventureWorks2012 database I can see all the stored procedures. Right clicking a stored procedure and choosing StoredProceedureName(...) drop-down, you display the stored procedure in the query window. You need to insert the parameters inside the parenthesis containing the ellipsis and run the query.

Examples are shown in the following two posts:

http://hodentekmsss.blogspot.com/2015/01/learn-querying-sql-server-2012-using.html

http://hodentekmsss.blogspot.com/2015/01/learn-querying-sql-server-2012-using_25.html

Tuesday, December 30, 2014

2014 was a mixed year

2014 was a mixed year. I lost my brother Dr. Vijaya Raghavan Krishnaswamy, a neuro-surgeon by profession. He left a void that cannot be filled.

I did not complete the book I was writing.

Regarding the blogs I did quite well with a record number of posts.
                                                 Year   Posts
Hodentek.blogspot.com           2013   94
                                                 2014   246

HodentekHelp.blogspot.com.  2013.  17
                                                 2014   56

HodentekMsss.blogspot.com   2013   34
                                                  2014  48
 
HoentekMobile.blogspot.com  2013   13
                                                  2014  

I started a new blog in 2014- http://hodentekPlus.blogspot.com.

I also found that a certain person was pilfering (http://hodentek.blogspot.in/2014/12/domain-name-service-dns-and-dns-changer.html) entire content from blog, my hardwork of about 10 years. I complained to Google without any success. I suppose this is not on Google's priority. Google wants every post that is stolen with proof of content stolen. There were over 900 posts in my blog and you can imagine the work involved.
 

Sunday, December 7, 2014

What is LINQ?

We know that a query is a question we pose to the database to retrieve some information that we would like to know. For example, in a database that consists of men and women, you may want to know how many men and how many women. Let us go a step further and say that there are people of all nationalities in the database of men and women. You may want to know how many women who hail from Europe are there. This is only filtering of the information but a query can much more complex. This is of course querying a database, let us say a relational database such as the SQL Server where you use the Structured Query Language(SQL), a special language you have to learn.

All data are not in relational databases and they could be in some kind of an XML document, a web service or something else. For example, in order to find some filtered content in an XML document you would use a language called XQuery which is not the same as SQL. This means there is need to learn another query language.

Beginning with Visual Studio 2008 and .NET Framework 3.5 Microsoft introduced LINQ which stands for Language-Integrated Query an innovation that made it possible to query a SQL Server database, an XML document, Web Services etc with a single lanugage and it is a first class query language.

In Visual Studio you can write LINQ in both VB and C# for any collection that supports IEnumerable or the generic IEnumerable interface (or to put it simply a collection in which one can go through the collection item by item).

For example you may have a list  of names ("John", "Tom", "June", "Diana") etc.  or  the number of rows in a database table , etc. and they can be queried using LINQ.

Need to query SQL Server with LinqPad, review the following posts:

http://hodentekmsss.blogspot.com/2014/12/learn-querying-sql-server-using-linq.html
http://hodentekmsss.blogspot.com/2014/12/learn-querying-sql-server-2012-using.html

Tuesday, December 2, 2014

What are the different frameworks you can use with Intel XDK App Designer project?

In the latest version of Intel XDK you can create one of four frameworks to work with. They are,
  • App Framework
  • BootStrap 3
  • jQuery Mobile
  • TopCoat
App Framework
Basically used for mobile devices and supports native OS such as Googl Android, Apple iOS, RIMBlackberry and Microsffot Windows 8. It has no outside dependencies and optimized for speed. It is Javascript library for mobile HTML5 apps.
http://app-framework-software.intel.com/

Bootstrap 3
It is an open source UI library mostly used for web. Although not meant for mobile devices it still works OK. It is heavy on CSS3 and uses jQuery
http://getbootstrap.com/

jQuery Mobile
Uses JQuery and meant for mobile and optimized for touch. Use HTML5 for UI design for rsponsive weeb and apps (smartphone, tablet and desktop).
http://jquerymobile.com/

Topcoat
Pure Open source CSS for clean mobile and web apps. Optimized for performance with no other dependencies. It has its origins in Adobe design.
http://topcoat.io/

Thursday, November 27, 2014

Can you access ODATA with PowerShell?

Yes you can. However you need to use PowerShell Version 4.0

Here is an example.
I take the example of using the ODATA service provided by ODATA.Org
Here is the URL of this service:
http://services.odata.org/OData/Odata.Svc

If you were to type this into you browser,you would see this.



This shows meta data of the collection in this service

Launch Windows PowerShell with elevated permissions.

Verify you are using Version 4
--------
PS C:\Windows\system32> $PSversionTable.PSversion
Major  Minor  Build  Revision
-----  -----  -----  --------
4      0      -1     -1

------------

Declare a $Categories variable as shown
$categories=Invoke-RestMethod http://Services.odata.org/OData/OData.svc/Categories
You will be returned to the next line if there are no errors
Let us see what is in categories
---------
PS C:\Windows\system32> $categories
id       : http://services.odata.org/OData/OData.svc/Categories(0)
category : category
link     : {link, link, link}
title    : title
updated  : 2014-11-27T21:11:29Z
author   : author
content  : content

id       : http://services.odata.org/OData/OData.svc/Categories(1)
category : category
link     : {link, link, link}
title    : title
updated  : 2014-11-27T21:11:29Z
author   : author
content  : content

id       : http://services.odata.org/OData/OData.svc/Categories(2)
category : category
link     : {link, link, link}
title    : title
updated  : 2014-11-27T21:11:29Z
author   : author
content  : content
------------------
Looks like there are three categories
Let us look at the titles and link of these categories
-------------
PS C:\Windows\system32> $categories.title
type                                                        #text
----                                                        -----
text                                                        Food
text                                                        Beverages
text                                                        Electronics

PS C:\Windows\system32> $categories.link
rel                                     title                                   href
---                                     -----                                   ----
edit                                    Category                                Categories(0)
http://schemas.microsoft.com/ado/200... Products                                Categories(0)/Products
http://schemas.microsoft.com/ado/200... Products                                Categories(0)/$links/Products
edit                                    Category                                Categories(1)
http://schemas.microsoft.com/ado/200... Products                                Categories(1)/Products
http://schemas.microsoft.com/ado/200... Products                                Categories(1)/$links/Products
edit                                    Category                                Categories(2)
http://schemas.microsoft.com/ado/200... Products                                Categories(2)/Products
http://schemas.microsoft.com/ado/200... Products                                Categories(2)/$links/Products