Dim stringsList As List(Of String).
Dim newString As String = String.Join(“,”, stringsList)
Monthly Archives: May 2013
Using C# Linq’s ToDictionary from DataTable
I have a sql query that I return into a DataTable:
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME IN (SELECT DBTABLE FROM MY_APP_SETTINGS)With this, I want to create a Dictionary<string, List<ColumnInfo>>, where the key is TABLE_NAME and ColumnInfo is a custom class with properties to match the other three fields returned in the query. Continue reading
DataTable to Dictionary(Of String, List(Of String)) using LINQ
If the DataTable is like below…
| COL1 | COL2 |
| Name | BABU |
| Name | RAO |
| Town | Nandyal |
| State | A.P. |
I you want to create a Dictionary(Of String, List(Of String)) like below from DataTable using LINQ…
| Key | Value |
| Name | BABU and RAO |
| Town | Nandyal |
| State | A.P. |
The query is… Continue reading
Code Review Checklist and Guidelines for C# Developers
Difference Between ASP.NET Web API and WCF
Introduction
This article describes the differences between the Web API and Windows Communication Foundation (WCF). And also describes how to choose between WCF and Web API.
What is the ASP. NET Web API
The ASP. NET Web API is a framework that uses the HTTP services and makes it easy to provide the response to the client request. The response depends on the request of the clients. The Web API builds the HTTP services, and handles the request using the HTTP protocols. The request may be GET, POST, DELETE, PUT. We can also say that the ASP. NET Web API:
- Is an HTTP service.
- Is designed for reaching the broad range of clients.
- Uses the HTTP application. Continue reading
Create Proxy Class For WCF Service Using svcutil.exe & CommandPrompt
There are couple of different options available to create proxy class for a WCF service in .Net. First one is to use “Add Service Reference” option available in visual studio and the second option is to use svcutil.exe utility. Although “Add Service Reference” option also invoke this utility implicitly but you can also go to visual studio command prompt and use this utility to generate proxy code that you can use in your client application. Continue reading
[FIX] Sql Server Management Studio intellisense not working even its enabled
Add Identity Column to Table Based on Order of Another Column
Read full article HERE
-- Create Table
CREATE TABLE TestTable (Col1 INT, Col2 VARCHAR(100))
GO
-- Insert Data
INSERT INTO TestTable (Col1, Col2)
VALUES (33, 'Pinal');
INSERT INTO TestTable (Col1, Col2)
VALUES (22, 'Nupur');
INSERT INTO TestTable (Col1, Col2)
VALUES (11, 'Shaivi');
GO Continue reading
Azure certification Exam:70-583 vs Exam:70-487
Microsoft offers two categories of exams; Those that are technical based (such as 70-487) and those that are Job-Role based (such as 70-583).
A technical based exam focuses on “How” to do stuff with a technology whereas a job-rolebased exam focuses on “Why, when and where” to do stuff with technology.
e.g. A technical based exam might ask “How to implement (code) IDisposable interface in a class?” whereas a job-role based exam might ask “Why and when you should implement the IDisposable interface”.
Whether you should do exam 70-583 or 70-487 really depends on whether you want to be a developer or a designer. If you’ve 3yrs experience as a developer, you should probably do 70-487 (and then maybe do 70-583 as I don’t believe you can be a developer without knowing how to design – IMOA).
