using System;
using System.Configuration;
using System.Collections.Generic;
using System.Data;
using System.Data.OleDb;
using System.Linq;
using System.Text;
using System.Reflection;
using System.Runtime.CompilerServices;
using System.Runtime.InteropServices;

using WebMessenger;

[assembly: AssemblyTitle("MessengerData")]
[assembly: AssemblyDescription("")]
[assembly: AssemblyConfiguration("")]
[assembly: AssemblyCompany("")]
[assembly: AssemblyProduct("MessengerData")]
[assembly: AssemblyCopyright("Copyright ©  2008")]
[assembly: AssemblyTrademark("")]
[assembly: AssemblyCulture("")]
[assembly: ComVisible(false)]
[assembly: Guid("c64f1fe5-a8e0-496c-9352-8af1a2f5ddda")]
[assembly: AssemblyVersion("1.0.0.0")]
[assembly: AssemblyFileVersion("1.0.0.0")]

namespace MessengerData
{
    class Program
    {
        static void Main(string[] args)
        {
            UserSessionDAO _userSessionDAO = new UserSessionDAO();
			_userSessionDAO.DeleteAll();

            string connectionString = ConfigurationManager.ConnectionStrings
                ["MessengerConnectionString"].ConnectionString;

            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();
                OleDbCommand command = new OleDbCommand(null, connection);
                command.CommandText = "SELECT * FROM [user]";

                using (OleDbDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        Console.WriteLine("{0} ({1})", reader["user_id"], reader["password"]);
                    }
                } // using (OleDbDataReader)

            } // using (OleDbConnection)

            Console.WriteLine(":end");
        } // Main()

    } // Program class

} // MessengerData namespace