[Release] Simple MsSql Handler

[Spirited42]

I'm going back to MySql because I like it better. Here's the sql handler I was using that works with Sql Express (When you install Visual Studio):

namespace 数据库
{
    using System;
    using System.Data.SqlClient; 

    public static class Connection
    {
        public static string Database, DataSource;
        public static byte Timeout;
        public static string ConnectionString
        {
            get
            {
                return @"Data Source=" + DataSource + ";"
                    + "AttachDbFilename=" + Database + @"\Project Resistance\Binaries\Database.mdf;"
                    + "Integrated Security=True;Connect Timeout=" + Timeout + ";User Instance=True";
            }
        }
        public static void Test()
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                try { conn.Open(); conn.Close(); }
                catch { Console.ForegroundColor = ConsoleColor.Red; 
                    Console.WriteLine("Database Problems Detected!"); 
                    Console.ResetColor(); Console.ReadLine(); 
                }
            }
        }
    }
}

namespace 数据库
{
    using System;
    using System.Data;
    using System.Data.SqlClient;

    public class SqlReader : IDisposable
    {
        public SqlDataReader DataReader = null;
        private SqlConnection conn = new SqlConnection(Connection.ConnectionString);
        public SqlReader(string command)
        {
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(command, conn);
                DataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch (Exception e) { Console.WriteLine(e); if (conn.State != System.Data.ConnectionState.Closed) conn.Close(); }
        }
        public void Dispose()
        {
            if (conn.State != ConnectionState.Closed)
                conn.Close();
            conn.Dispose();
            DataReader = null;
            conn = null;
        }
    }
}

namespace 数据库
{
    using System;
    using System.Data.SqlClient;

    public class SqlCmd
    {
        public SqlCmd(string command)
        {
            using (var conn = new SqlConnection(Connection.ConnectionString))
            {
                try
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(command, conn);
                    cmd.ExecuteNonQuery();
                    cmd.Dispose();
                    conn.Close();
                }
                catch (Exception e) { Console.WriteLine(e); if (conn.State != System.Data.ConnectionState.Closed) conn.Close(); }
                conn.Dispose();
            }
        }
    }
}

Inside my configuration file:

[Database]
DataSource = .\SQLEXPRESS
Timeout = 30

Helpful Links:

[.Ryu]

Can you not delete this one this time <_<

[Spirited42]

Originally Posted by .Ryu

Can you not delete this one this time <_<

I don't plan to delete it but I wish you would delete that comment and stop posting it every time I release something.

[xScott]

thats an odd namespace name (:
anyway, nice release fang.

[KraHen]

It`s a really easy "wrapper"(?) to implement, IMO everyone developing a server should be able to figure something this straightforward out on their own.

I appreciate that you want to help, but IMO this isn`t the way to go for it. Just my opinion though.

[Spirited42]

Originally Posted by KraHen

It`s a really easy "wrapper"(?) to implement, IMO everyone developing a server should be able to figure something this straightforward out on their own.

I appreciate that you want to help, but IMO this isn`t the way to go for it. Just my opinion though.

Well, it took me a good few hours to figure out, but then again... my laptop was having serious issues with Sql RC2.

[pintser]

 Spoiler

Originally Posted by Spirited

I'm going back to MySql because I like it better. Here's the sql handler I was using that works with Sql Express (When you install Visual Studio):

namespace 数据库
{
    using System;
    using System.Data.SqlClient; 

    public static class Connection
    {
        public static string Database, DataSource;
        public static byte Timeout;
        public static string ConnectionString
        {
            get
            {
                return @"Data Source=" + DataSource + ";"
                    + "AttachDbFilename=" + Database + @"\Project Resistance\Binaries\Database.mdf;"
                    + "Integrated Security=True;Connect Timeout=" + Timeout + ";User Instance=True";
            }
        }
        public static void Test()
        {
            using (var conn = new SqlConnection(ConnectionString))
            {
                try { conn.Open(); conn.Close(); }
                catch { Console.ForegroundColor = ConsoleColor.Red; 
                    Console.WriteLine("Database Problems Detected!"); 
                    Console.ResetColor(); Console.ReadLine(); 
                }
            }
        }
    }
}

namespace 数据库
{
    using System;
    using System.Data;
    using System.Data.SqlClient;

    public class SqlReader : IDisposable
    {
        public SqlDataReader DataReader = null;
        private SqlConnection conn = new SqlConnection(Connection.ConnectionString);
        public SqlReader(string command)
        {
            try
            {
                conn.Open();
                SqlCommand cmd = new SqlCommand(command, conn);
                DataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch (Exception e) { Console.WriteLine(e); if (conn.State != System.Data.ConnectionState.Closed) conn.Close(); }
        }
        public void Dispose()
        {
            if (conn.State != ConnectionState.Closed)
                conn.Close();
            conn.Dispose();
            DataReader = null;
            conn = null;
        }
    }
}

namespace 数据库
{
    using System;
    using System.Data.SqlClient;

    public class SqlCmd
    {
        public SqlCmd(string command)
        {
            using (var conn = new SqlConnection(Connection.ConnectionString))
            {
                try
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(command, conn);
                    cmd.ExecuteNonQuery();
                    cmd.Dispose();
                    conn.Close();
                }
                catch (Exception e) { Console.WriteLine(e); if (conn.State != System.Data.ConnectionState.Closed) conn.Close(); }
                conn.Dispose();
            }
        }
    }
}

Inside my configuration file:

[Database]
DataSource = .\SQLEXPRESS
Timeout = 30

Helpful Links:

+1
Dummies:

 Spoiler

(for all dummies:

Namespace 数据库 = Namespace Database)

to the creator:
伟大的工作，先生！

[.Kinshi]

Originally Posted by pintser

+1
Dummies:

 Spoiler

(for all dummies:

Namespace 数据库 = Namespace Database)

to the creator:
伟大的工作，先生！

哦 我的上帝，我可以使用谷歌翻译的！

[pintser]

上午我好，还是什么？
---btw---
你是假的!
----------
xd

[Spirited42]

其实...我没用Google译者
Translation: Actually, I didn't use Google Translator.
Try typing that sentence in and see if you get what I typed in Chinese. =]

Oh, 和感谢你

[Yoshimitsu™]

我喜欢在后院下雨时雨水冰雹岩浆。

[Spirited42]

Originally Posted by Yoshimitsu™

我喜欢在后院下雨时雨水冰雹岩浆。

._. that was a messed up sentence.
K, no more Chinese. lol

[Korvacs]

Ok enough of the chinese, everytime you write it you break a very simple rule >_>".

Not sure what the idea behind using Chinese was but i cant imagine its very useful when it comes to actually writing code, since you have to use it everytime you use that namespace..