[Base]MSSQL for your server.

[BaussHacker]

First of all you need to download Sql Server.


Well first of all we will make a Sql class.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
    public class SqlWrapper
    {
    }
}

Then we define a namespace called System.Data.SqlClient.

using System.Data.SqlClient;

put this function as it will be called, when creating a new instance of the SqlWrapper class.

        public SqlWrapper()
        {
        }

This should be your code so far:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    public class SqlWrapper
    {
        public SqlWrapper()
        {
        }
    }
}

We will put a string parameter in it as well. Call it connectionString.

        public SqlWrapper(string connectionString)
        {
        }

Now make a variable an SqlConnection called Connection.

SqlConnection Connection;

Now create a new instance of the SqlConnection class inside the previous function.

        public SqlWrapper(string connectionString)
        {
            Connection = new SqlConnection(connectionString);
        }

This should be the code so far:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    public class SqlWrapper
    {
        public SqlConnection Connection;
        public SqlWrapper(string connectionString)
        {
            Connection = new SqlConnection(connectionString);
        }
    }
}

For updating and writing we will just use a simple Sql Command.
Make a new method called Command with the string parameter _command.

        public void Command(string _command)
        {
        }

First of all we will create the command using our previous connection.

SqlCommand Command = new SqlCommand(_command, Connection);

Now we put a try, catch and a finally block.

            try
            {
            }
            catch
            {
            }
            finally
            {
            }

Inside the try we will open the connection and execute our command.
You open the connection by doing this:

Connection.Open();

To execute the command we can use this:

Command.ExecuteNonQuery();

This should be our code so far in the method:

        public void Command(string _command)
        {
            SqlCommand Command = new SqlCommand(_command, Connection);
            try
            {
                Connection.Open();
                Command.ExecuteNonQuery();
            }
            catch
            {
            }
            finally
            {
            }
        }

We will catch an exception in the catch block, if any exception is thrown.

            catch (Exception e)
            {
                Console.WriteLine(e);
            }

And in the finally we will close our connection.

Connection.Close();

This should be the command method:

        public void Command(string _command)
        {
            SqlCommand Command = new SqlCommand(_command, Connection);
            try
            {
                Connection.Open();
                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            finally
            {
                Connection.Close();
            }
        }

For reading I will just give one example for reading string. you can make rest methods or do your own, if you feel it's necessary. I don't know other ways to read as this is the only way I have used and been knowing. If anybody knows other ways that's better or easier, feel free to enlighten me.

Create a new function for a string called ReadString.

        public string Read(string Select, string From, uint UID)
        {
        }

Select is the column and From is the table. UID is what the UID should be equal to.

Now put this 2 strings at the top of the function

string Value = "";
            string Command = "SELECT " + Select + " FROM " + From + " WHERE UID = " + UID;

Value is the value we get, which we will return and Command is the Sql Command to select a column from a table.

Now create a command using the previous connection again.

SqlCommand SQLCommand = new SqlCommand(Command, Connection);

And right under put a new variable for SqlDataReader called Reader.

SqlDataReader Reader;

Now make the try, catch and finally blocks like previous, but let the try block be clean.

            try
            {
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            finally
            {
                Connection.Close();
            }

First of all we will open the connection.

Connection.Open();

Now, instead of executing the command directly, then we will execute a reader, using our command.

Reader = SQLCommand.ExecuteReader();

Now make a while loop as it will be looping until it has got through all of the objects that's supposed to be read. In this case we only have one.

                while (Reader.Read())
                {
                }

Now we got to make Value equal to the object that our reader has read.

Value = Reader[Select].ToString();

Make sure it's ToString as it's an object and that means we need to define the type of it either by ToString or type casting ex. (int)Reader[Select]; Anyways, after the while loop we will close the reader.

Reader.Close();

Now at the bottom of the function we will return the data.

return Value;

This should be the whole code of the SqlWrapper class.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
    public class SqlWrapper
    {
        public SqlConnection Connection;
        public SqlWrapper(string connectionString)
        {
            Connection = new SqlConnection(connectionString);
        }
        public void Command(string _command)
        {
            SqlCommand Command = new SqlCommand(_command, Connection);
            try
            {
                Connection.Open();
                Command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            finally
            {
                Connection.Close();
            }
        }
        public string Read(string Select, string From, uint UID)
        {
            string Value = "";
            string Command = "SELECT " + Select + " FROM " + From + " WHERE UID = " + UID;

            SqlCommand SQLCommand = new SqlCommand(Command, Connection);
            SqlDataReader Reader;

            try
            {
                Connection.Open();
                Reader = SQLCommand.ExecuteReader();
                while (Reader.Read())
                {
                    Value = Reader[Select].ToString();
                }
                Reader.Close();
            }
            catch (Exception e)
            {
                Console.WriteLine(e);
            }
            finally
            {
                Connection.Close();
            }

            return Value;
        }
    }
}

About the connection string, that's basically your database informations, example:

Data Source=SERVERNAME;Initial Catalog=DATABASE;Integrated Security=True

SERVERNAME is the Sql Server name.
DATABASE is the Database name.

There is other properties like password etc. you can be using them as well.
Might take a look here:

I think that's it.

How can we use it then?

Example:

            SqlWrapper wrapper = new SqlWrapper("Data Source=SERVERNAME;Initial Catalog=DATABASE;Integrated Security=True");
            Char.Name = wrapper.Read("Name", "Characters", Char.UID);

[Spirited]

(not asking for anyone to agree, just sharing)

[BaussHacker]

Originally Posted by Fаng

(not asking for anyone to agree, just sharing)

[Spirited]

Originally Posted by BaussHacker

"Overall, MySQL has the edge in price as it is free, and performance can’t be conclusively shown to be any worse than MS SQL"

Really boils down to preference again xP like it always does.

[BaussHacker]

Originally Posted by Fаng

"Overall, MySQL has the edge in price as it is free, and performance can’t be conclusively shown to be any worse than MS SQL"

Really boils down to preference again xP like it always does.

But it's not better or worse, why not use MSSQL as it's already implented and can give you a lot more abilities, while working with C#? Such as things for your site etc. ? I see no reasons to use MySQL in this case, other than if you're hosting on Linux or websites using PHP. As peoples use C# here, then using MSSQL would be so much easier and it would literally not do anything other than improve your abilities of what you can. Let's say you make a site in ASP.NET, then it would be 100x times easier to use MSSQL as it's already implented in the membership etc. that way you can interact your server with your whole website. I know not many uses ASP.NET here and 99% uses PHP.

[Korvacs]

Stored procedures Bauss for submitting data, very fast, moves data handling onto the server away from the application.

Personally i prefer the C# intergration for MSSQL and thats really the only reason i use it over MySQL, even if your using PHP you can get MSSQL plugins for PHP which allow you to use it almost as easily as MySQL.

[BaussHacker]

Originally Posted by Korvacs

Stored procedures Bauss for submitting data, very fast, moves data handling onto the server away from the application.

Personally i prefer the C# intergration for MSSQL and thats really the only reason i use it over MySQL, even if your using PHP you can get MSSQL plugins for PHP which allow you to use it almost as easily as MySQL.

I will look into that, thank you.