How to call object from one class to another in C#

Like this,

public void QueryExecution(string SQLQuery) { RSProfile profile = new RSProfile(); RSDatabaseConnectionCreator instance = new RSDatabaseConnectionCreator(profile); SqlConnection conn = instance.CreateConnection(...); SqlCommand command = new SqlCommand(SQLQuery, conn); var file = new StreamWriter(@"D:\Project\rsDeployer\ImportedQuery.txt"); file.WriteLine(command); file.Close(); conn.Close(); } 

You also told that you want to inherit from this class, here is another approach,

public class RSDatabaseConnectionCreator : LoggerBase { public virtual object CreateConnection() // by virtual you can override it. { return new object(); } } public class AnotherClass : RSDatabaseConnectionCreator { public AnotherClass() { CreateConnection(); // by inheriting RSDatabaseConnectionCreator , you can reach public functions. } public override object CreateConnection() // or you can override it { // here might be some user Login check return base.CreateConnection(); // then you open connection } } 

Hope helps,

Hope this is what you are requesting for

public class ClassX { private RSProfile _rsprofile; RSDatabaseConnectionCreator _dbConnectionCreator; private SqlConnection _sqlConnection; public ClassX() { _rsProfile = xxx; // Get the RSProfile object _dbConnectionCreator = new RSDatabaseConnectionCreator (_rsProfile); RSDatabaseNames databaseName = yyy; // get the RSDatabaseNames var useWindowsAuthentication = true; var testConnection = false; _sqlConnection = _dbConnectionCreator.CreateConnection(databaseName,useWindowsAuthentication ,testConnection ); } } 

This is how you do it. Apologies for a major blunder in the earlier answer. This one has the connection surrounded by a using.

 namespace rsDeployer.Common.SQLServerCommunication { public class ConsumerClass { public void QueryExecution(string SQLQuery) { var profile = new RsProfile(); var rsConnectionCreator = new RSDatabaseConnectionCreator(profile); using(var sqlConnection = rsConnectionCreator.CreateConnection(...Parameters here...)){ SqlCommand command = new SqlCommand(SQLQuery, sqlConnection ); } var file = new StreamWriter(@"D:\Project\rsDeployer\ImportedQuery.txt"); file.WriteLine(command); file.Close(); } } } 

You can inject the connection creator into the consumer class through the constructor.

public class Consumer { private RSDatabaseConnectionCreator _connectionCreator; // Constructor injection public Consumer (RSDatabaseConnectionCreator connectionCreator) { _connectionCreator = connectionCreator; } public void QueryExecution(string SQLQuery) { using (var conn = _connectionCreator.CreateConnection(dbName, true, true)) { if (conn != null) { ... } } } } 

Note: The using statement automatically closes the connection.

Usage

var connectionCreator = new RSDatabaseConnectionCreator(profile); var consumer = new Consumer(connectionCreator); consumer.QueryExecution(sqlQuery); 

If you want to inject the connection creator at each call of QueryExecution, you can inject it directly into the method as an additional parameter, instead.

public void QueryExecution(string SQLQuery, RSDatabaseConnectionCreator connectionCreator) { using (var conn = connectionCreator.CreateConnection(dbName, true, true)) { if (conn != null) { ... } } } 

Usage

var connectionCreator = new RSDatabaseConnectionCreator(profile); var consumer = new Consumer(); consumer.QueryExecution(sqlQuery, connectionCreator);