CODEWITHSUNDEEP
c#sql-servervisual-studio-2010
alejandro carnero
alejandro carnero

Reputation: 1784

class for two connections

Normally i use this class to create a sqlconnection :

namespace IntraFaz
{   
   class Tconex
   {
      public static SqlConnection GetConnection()
      {
         //string str = "Data Source=SQL-PC;Initial Catalog =ifdcontroladoria3;uid =sa;pwd = admin2012";

         string str = "Data Source=300.161.430.110 ;Initial Catalog =Pirulim;uid =sa;pwd = per#3";
         SqlConnection con = new SqlConnection(str);
         con.Open();

         return con;
      }
   }
}

Late i call this class in the forms to create new sqlconnection with this 

SqlConnection conec1 = Tconex.GetConnection();

how i need to write the class to get two distint connections i want something like this 

public static SqlConnection GetConnection()
{       
   string str = "Data Source=300.161.430.110 ;Initial Catalog =Pirulim;uid =sa;pwd = per#3";
   string str2 = "Data Source=300.161.430.112 ;Initial Catalog =Pirulim;uid =sa;pwd = per#4";

   SqlConnection con = new SqlConnection(str);
   con.Open();

   SqlConnection con = new SqlConnection(str2);
   con.Open();

   return con;
}

Upvotes: 0

Views: 77

Answers (5)

apomene
apomene

Reputation: 14389

Only difference in your connection is the passowrd so: 

public static SqlConnection GetConnection(string pass)
   {   
       string str = "Data Source=300.161.430.110 ;Initial Catalog =Pirulim;uid =sa;pwd ="+pass;        
       SqlConnection con = new SqlConnection(str);
       con.Open();         
       return con;
   }

On later implementation if other parameters alter (e.g userid) you can add it as argument to your method...

Upvotes: 0

Heinzi
Heinzi

Reputation: 172270

public static Tuple<SqlConnection, SqlConnection> GetTwoConnections()
{
    ...
    SqlConnection con1 = new SqlConnection(str1);
    SqlConnection con2 = new SqlConnection(str2);
    con1.Open();
    con2.Open();

    return Tuple.Create(con1, con2);
}

Usage:

var cons = GetTwoConnections();
using (cons.Item1, cons.Item2)
{
    // use first connection as cons.Item1 and second one as cons.Item2
}

Upvotes: 0

Thorsten Dittmar
Thorsten Dittmar

Reputation: 56697

public static SqlConnection[] GetConnections() 
{
    SqlConnection con1 = new SqlConnection(str1);
    SqlConnection con2 = new SqlConnection(str2);
    con1.Open();
    con2.Open();

    return new SqlConnection[] { con1, con2 }; 
}

Upvotes: 1

Albireo
Albireo

Reputation: 11095

Create a class to hold the result of the method an return that.

public class TheseConnectinsHaveThisPurpose
{
    public SqlConnection ThisConnectionHasThisPurpose { get; set; }

    public SqlConnection ThisConnectionHasThisOtherPurpose { get; set; }
}

Upvotes: 0

bjnr
bjnr

Reputation: 3437

public static SqlConnection GetConnection()
{

    string str = "Data Source=300.161.430.110 ;Initial Catalog =Pirulim;uid =sa;pwd = per#3";


    SqlConnection con = new SqlConnection(str);
    con.Open();

    return con;
}

public static SqlConnection GetConnection2()
{

    string str2 = "Data Source=300.161.430.112 ;Initial Catalog =Pirulim;uid =sa;pwd = per#4";


    SqlConnection con = new SqlConnection(str2);
    con.Open();


    return con;
}

Upvotes: 1

Related Questions