Do You Know?

Do You Know? [20-Oct-2010][038] [SQL Server]

2010-10-19T21:03:00.000-07:00

You are writing a query in Management console and not able to remember the exact spelled field name?, which is most time common when we are working like is it Employee_ID or EmployeeID.. :)

no worries, here is a short cut for you.

just write query you are opting for, and select the table name and press ALT + F1. That is, all Table and Column details right in front of you!

Do You Know? [19-May-2010][037] [ASP.NET - WCF]

2010-05-19T05:40:00.000-07:00

WCF (Windows Communication Foundation) was code named as "Indigo".

Do You Know? [19-May-2010][036] [ASP.NET - WCF Contracts]

2010-05-19T03:34:00.000-07:00

All WCF services expose Contracts. The contract is never platform-specific and contracts describes what the service actually does. WCF defines four types of contracts:

[1] Service contracts - Describe which operations the client can perform on the service.

[2] Data contracts - Define which data types are passed to web service and which data tyes retrieved from the service.

[3] Fault contracts - Define which errors are raised by the service, and how the service handles the errors to its calling clients.

[4] Message contracts - Allow the services to interact directly with messages.

Do You Know? [19-May-2010][035] [ASP.NET - WCF Transport Schemas]

2010-05-19T03:31:00.000-07:00

WCF platform supports 5 transport schemas:

[1] http - uses http for transport, and can also use https for secure transport like - http://localhost:8001/MyService

[2] tcp - uses net.tcp for transport and typically include a port number like - net.tcp://localhost:8002/MyService

[3] ipc (named pipes) - uses net.pipe for transport - but WCF services that uses ipc as transport can only accept calls from same machine only. You need to specify machinename or localhost followed by pipe name. as - net.pipe://localhost/MyPipe

[4] msmq - uses net.msmq for transport, and its use the Microsoft Message Queue (MSMQ). as - net.msmq://localhost/MyService. Queues can be private or public. For private Queue - you need to specify the queuetype in address itself as - net.msmq://localhost/private/MyService

[5] peer network - uses net.p2p for transport, to indicate the use of the Windows peer network transport

Do You Know? [18-May-2010][034] [Web Development]

2010-05-18T08:40:00.000-07:00

A Question: Suppose you need to develop a web application for which you are not sure in which technology (java/.NET/php) of the Presentation Layer will be based on; (I mean you are still don't know what technology will be used for Presentation Layer); and you need to FOCUS on Business Layer & Data Layer (or anything else that you need to create for an n-Layered Architecture). WHAT will be your approach?

Answer is: Creating Web Service. That can be exposed to Presentation Layer which can be based on any technology. Because Web Services use Extensible Markup Language (XML) messages which is respected by any technology :)

More details on SOA (Service Oriented Architecture) @ SOA - Wiki

Do You Know? [18-May-2010][033] [ASP.NET - WCF]

2010-05-18T08:38:00.000-07:00

Most of the WCF functionality is included in a single assembly called System.ServiceModel.dll, located in the System.ServiceModel namespace

Do You Know? [18-May-2010][032] [.NET 4.0 - Tuple]

2010-05-17T21:34:00.000-07:00

A tuple (introduced in .NET 4.0) is a typed collection of fixed size. Tuples were introduced for interoperability with F# and IronPython, but can also make your code more concise.

Tuples are very easy to create:
Tuple<int, int, int, int, int> TuppleObj = Tuple.Create(2, 4, 6, 8, 10);

Individual items in the tuple can be queried with the Item property:
MultiplesOfTwo.Item2;

Tuples might contain up to seven elements; if you want to add more items, you have to pass in another tuple to the Rest parameter:
var multiples = new Tuple<int, int, int, int, int, int, int,Tuple<int,int,int>>(2, 4, 6, 8,10, 12, 14, new Tuple<int,int,int>(3,6,9));

Items in the second tuple can be accessed by querying the Rest property:
multiples.Rest.Item1;

more can be found on Tuple @ Tuple Class

Do You Know? [17-May-2010][031] [.NET 4.0 - PreApplicationStartMethodAttribute]

2010-05-16T21:21:00.000-07:00

if anybody would ask you which is the event that execute when an ASP.NET application get started.. correct, it is Application_Start event.

BUT, not anymore now :)

because in ASP.NET 4.0 - a new attribute "PreApplicationStartMethodAttribute" is introduced which allows you to run any code very early in the ASP.NET - like an application starts up. Yes, I mean very early, even before Application_Start.!!

find more details @ PreApplicationStartMethodAttribute

Do You Know? [17-May-2010][030] [.NET 4.0 - BuildManager.AddReferencedAssembly]

2010-05-16T21:15:00.000-07:00

When you need to require some assembly reference in your application, you would add it via "Add Reference.." dialog which would in turn add reference entry inside section of your application's web.config file.

In ASP.NET 4.0, Another new method is added which allows you to add an assembly reference to the application’s list of referenced assemblies. This is the same thing like adding an assembly to the of web.config. It allows you to programmatically add references to assemblies that may be needed by your application.

like it! me too. Its always exciting to do something programatically/dynamically rather than increasing size of you web.config file ;)

Do You Know? [14-May-2010][029] [ASP.NET - Web Service]

2010-05-14T00:05:00.000-07:00

A New post has been made on "How to call/Invoke a web service without adding web reference" by generating proxy class through WSDL.exe utility @ How to call/Invoke a web service without adding web reference

Do You Know? [13-May-2010][028] [Framework 4.0 - Lazy]

2010-05-12T22:44:00.000-07:00

in .NET 4.0 - has introduced a new type called "Lazy".

Lazy allows you to have lazy initialization functionality. That is you can declare a variable with Lazy which saved allocating memory until the object is actually get used in your code. That is, memory will not be allocated to that variable untill that object get used in the code.

So, if you end up with never accesing your object variable of type Lazy - it will be never allocated any memory resources. :)

So useful to declare a heavy or expensive objects where you require to have good responsiveness of UI-based application.

Also, you can have ability to initialize Value type or null types with Lazy Initialization. For, example think of declaring a class of type Lazy.

Do You Know? [12-May-2010][027] [Visual Studio - Show code covered by intellisense]

2010-05-11T22:40:00.000-07:00

IntelliSense is the greatest help MS provided in Visual Studio Environment.
Even IntelliSense in Visual Studio 2010 got 3 to 5 times faster then ever.

While you work in Visual Studio 2008/10 and as you write code; the IntelliSense pop-up gets come out, but if you need to view the code which is covered by the IntelliSense pop-up, you just need to press and hold the Ctrl key, and the IntelliSense pop-up becomes transparent so that you can view the code that is below the pop-up. :)

Do You Know? [11-May-2010][026] [DotNetNuke Scheduler]

2010-05-11T01:41:00.000-07:00

A New post has been made on "How to create DotNetNuke Scheduler for executing disconnected/confinuous process" @ How to create DotNetNuke(DNN) Scheduler

Do You Know? [10-May-2010][025] [C#]

2010-05-10T01:57:00.000-07:00

How would you rename a File in C#?

There is no dedicated method in System.IO class to rename a file (so, don't search for File.Rename :))

You need to use Move() method to rename a file with the same path as:

string strSourceFile = "c:\\New folder\\test.txt";
string strRenamedFile = "c:\\New folder\\test123.txt";

File.Move(strSourceFile,strRenamedFile);

Do You Know? [09-May-2010][024] [Visual Studio 2010 - Framework Targetting]

2010-05-08T20:09:00.000-07:00

"Framework Targeting" is some feature that is already been introduced in Visual Studio 2008 where you can select the framework from "Open Dialogue.." which would be appropriate to your application.

In VS2010 the Toolbox and Properties windows are filtered to display functionality available in the targeted framework version. Previously, some properties that were not available in the targeted framework would still be exposed. VS2010 will even try to display the correct version of third-party components for the targeting framework version.

Do You Know? [06-May-2010][023] [ASP.NET - System.Net.Mail]

2010-05-06T06:29:00.000-07:00

We use system.Net.Mail namespace to send the mail and implementing mail functionality in .NET.

Question is - Can We encrypt messages using s/mime or PGP Key when we use System.Net.Mail to send mails?

Answer is - We can't. Reason is - System.Net.Mail does not support encrypted messages.

Do You Know? [05-May-2010][022] [Visual Studio 2010 - Box Selection]

2010-05-04T12:09:00.000-07:00

Box Selection is one of my favorite feature included in Visual Studio 2010.
This feature allows you to quickly modify many lines of code by creating a box around those line of code.

The Scenario like you need to change the access modifiers of all the members of one scope - you can use Box Selection.

To use Box Selection, you need to put the cursor where you want to make the change, and then hold down Shift + Alt + combination with the arrow keys to create a "box" where up to the line where the change need to be applied.

Finally, enter your change and it will be applied to all the selected lines.
Check out in below short video.

Do You Know? [05-May-2010][021] [Visual Studio 2010 IDE]

2010-05-04T11:24:00.000-07:00

There is a new ability/feature support is included in Visual Studio 2010 IDE.
That is - ability to drag the windows outside of IDE !!!

Yes, you can drag any docked/floating window outside of the IDE.
Even, You can drag out Code Behind or Design Windows as well (As i said any window inside IDE :)

Do You Know? [04-May-2010][020] [Visual Studio 2010]

2010-05-04T10:52:00.000-07:00

R# & Refector are the features which are included in VS2010 IDE which are only available as Add-On Product in previous version of Visual Studio

Do You Know? [04-May-2010][019] [Visual Studio 2010 IDE]

2010-05-04T09:09:00.000-07:00

Go Thru Tools Menu > Extension Manager.

And That will open "Extension Manager" Dialog which will show many Power Tools online to download which would enhance and improve usefulness of your IDE. They add additional functionality to various parts of your IDE. One of them is I like > PowerCommands 10.0

Do You Know? [02-May-2010][018] [DotNetNuke - Skinning]

2010-05-02T09:17:00.000-07:00

The Only Building Blocks of DotNetNuke Skinning are:

[1] The HTML Page Structure which you are using/creating to create Pane Structure.

[2] The XML Tokens; If any - which are being used in the HTML Pane Structure.

[3] CSS file and Images which you are using in the HTML Page.

[4] Dottype file in which you would define correct dotcype for your skin.

Do You Know? [02-May-2010][017] [DotNetNuke - Portal Alias]

2010-05-02T07:26:00.000-07:00

When DNN receives the first page/browser request, a look-up against the defined portal aliases (in PortalAlias table OR from Admin Menu > Site Settings) is done. If the hostname by which you have requested pages from DNN is not found in the list of portal aliases, then DNN will redirect to the first available portal alias of the first portal.

Do You Know? [02-May-2010][016] [DotNetNuke - Skinning]

2010-05-02T06:57:00.000-07:00

The DotNetNuke Design Challenge was an amazing success! Twentyfive skins were submitted by 19 designers in 4 categories and all of their work is on display and available for you to download and use. Their work was assessed by our esteemed judges who awarded the category winners based on different attributes like design, educational value, implementation and technical merit. The Community Favorite was chosen by popular vote!

Skins available to download and use at here -
DotNetNuke Design Challenge

Do You Know? [02-May-2010][015] [DotNetNuke - Publish Website Option]

2010-05-02T06:48:00.000-07:00

Theoretically - You won't use the in-built Visual Studio Publish option (Publish Website.. menu option in server explorer) to move your DotNetNuke Site to a live environment. Because that scenario is not supported.

Do You Know? [01-May-2010][014] [SQL Server 64bit - Reading excel file in SP]

2010-05-01T02:40:00.000-07:00

When you need to open and read an excel file in an SQL Stored Procedure (SQL Server 32 bit), you can do that via below query:

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 5.0;HDR=Yes; IMEX=1;Database=D:\TestFile\book1.xls','SELECT * FROM [sheet1$]')

But, this will only works for 32bit SQL Server installation. And it won't work for 64bit SQL Server installation. The Reason is Jet provider does not have 64bit version.

So, todo the same task/operation you need to use ACE OleDb Provider as:

SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;HDR=Yes; IMEX=1;Database=D:\TestFile\book1.xls','SELECT * FROM [sheet1$]')

Per-rquesites:

[1] You need to download latest ACE connectivity components from here: AccessDatabaseEngine.exe

[2] And Execute below query (having selcet master db):

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

This will allow reading excel from sql server.

Help & Reference from: Nikunj Mochi (SSE)