I've a connection string saved to Properties.Settings.Default, i need to use an sql connection in all classes without having to declare it everytime, so how should it be declared?推荐答案实际上,您不需要在任何地方都使用单个 SqlConnection .更好的方法是创建一个类来管理您的数据访问.通常,这是数据访问层(DAL)的职责.DAL是处理所有与数据库相关的东西的一组类.You actually don't need to use a single SqlConnection everywhere. A better approach would be to create a class to manage you data access. Typically this is the duty of your Data Access Layer (DAL). DAL is a set of classes that handle all the database related stuff.为此目的一个非常简单的类可能是这样的:A very simple class for this purpose could be something like this:public class DatabaseManager{ private static DatabaseManager _instance; private DatabaseManager() { } static DatabaseManager() { _instance = new DatabaseManager(); } public DatabaseManager Instance { get { return _instance; } } private string GetConnectionString() { return Properties.Settings.Default.MyConnectionString; } public SqlConnection CreateConnection() { return new SqlConnection(GetConnectionString()); }}您可以扩展此类,以包含其他方法来执行查询.You can extend this class to contain another methods to execute your queries.我强烈建议您使用 ORM(对象关系映射器),例如实体框架.I highly recommend you to use an ORM (Object-Relational Mapper) like Entity Framework. 这篇关于在c#全局连接中要在所有类中使用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-22 17:48
查看更多