25 lines
695 B
C#
25 lines
695 B
C#
using Logic.Exceptions;
|
|
using System.Data.SqlClient;
|
|
|
|
namespace Data
|
|
{
|
|
public static class SqlConnectionHelper
|
|
{
|
|
private static string connectionString = "Server=mssqlstud.fhict.local;Database=dbi509645;User Id=dbi509645;Password=sNPNBm*BX!6z8RM;";
|
|
public static SqlConnection CreateConnection()
|
|
{
|
|
SqlConnection connection = new SqlConnection(connectionString);
|
|
try
|
|
{
|
|
connection.Open();
|
|
}
|
|
catch (SqlException e)
|
|
{
|
|
throw new DatabaseNetworkException("Unable to access FHICT VDI database", e);
|
|
}
|
|
|
|
return connection;
|
|
}
|
|
}
|
|
}
|