SQLConnect/Program.cs at master · sveroa/SQLConnect · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Data.SqlClient;
usingSystem.Data;
usingSystem.Configuration;
usingSystem.Globalization;

namespaceSQLConnect
{
classProgram
{
privatestaticstringGetConnectAs(SqlConnectionconn)
{
SqlCommandcmd=newSqlCommand("SELECT SUSER_SNAME()",conn);
stringuser=(string)cmd.ExecuteScalar();
returnuser;
}

privatestaticstringGetServerProperty(SqlConnectionconn,stringprop)
{
SqlCommandcmd=newSqlCommand("SELECT SERVERPROPERTY('"+prop+"')",conn);
varval=cmd.ExecuteScalar();
returnval.ToString();
}

privatestaticstringGetServerCollation(SqlConnectionconn)
{
returnGetServerProperty(conn,"Collation");
}

privatestaticstringGetServerEdition(SqlConnectionconn)
{
stringtmp=GetServerProperty(conn,"Edition");
stringengVer=GetServerProperty(conn,"EngineEdition");
intver=Convert.ToInt16(engVer);
switch(ver)
{
case1:tmp+=" (Personal)";break;
case2:tmp+=" (Standard)";break;
case3:tmp+=" (Enterprise)";break;
case4:tmp+=" (Express)";break;
}
returntmp;
}

privatestaticstringSQLVersion(SqlConnectionconn)
{
stringtmp=conn.ServerVersion;
string[]serverVersionDetails=tmp.Split(newstring[]{"."},StringSplitOptions.None);
intversionNumber=int.Parse(serverVersionDetails[0]);
switch(versionNumber)
{
case8:tmp="SQL Server 2000";break;
case9:tmp="SQL Server 2005";break;
case10:tmp="SQL Server 2008";break;
case11:tmp="SQL Server 2012";break;
case12:tmp="SQL Server 2014";break;
case13:tmp="SQL Server 2016";break;
default:tmp=string.Format("SQL Server {0}",versionNumber.ToString());break;
}
returntmp;
}

staticvoidMain(string[]args)
{
stringconnStr=args[0];

varcmd=newArguments(args);

try
{
using(SqlConnectionconn=newSqlConnection(connStr))
{
Console.WriteLine("Connecting using '"+connStr+"'");

conn.Open();

Console.WriteLine("Successfully connected as '"+GetConnectAs(conn)+"'");
Console.WriteLine("Client name: "+conn.WorkstationId);
Console.WriteLine("Server version: "+conn.ServerVersion+" ==> "+SQLVersion(conn));
Console.WriteLine("Server Edition: "+GetServerEdition(conn));
Console.WriteLine("Server collation: "+GetServerCollation(conn));

conn.Close();

Console.WriteLine("Successfully disconnected");
}
}
catch(Exceptionex)
{
Console.WriteLine("ERROR: "+ex.Message);
}

}
}
}