如何将web服务dbConnection.vb更改为c代码
本文关键字:代码 vb dbConnection web 服务 | 更新日期: 2023-09-27 17:58:28
嗨,我是c#的新手,我必须在c#中编写Web服务(btw企业对企业)
但我通常在vb中这样做,所以我不确定它在C#中的dbconnection是什么样子.如果能给我看一些链接,帮助我做网络服务(顺便说一句,企业对企业)现在我已经将服务器中的sql数据库连接到web服务这是我的dbconnection.vb,所以如何将其更改为c sharp,希望任何人都能向我展示c#中的代码外观
Imports Microsoft.VisualBasic
Imports System.Data.SqlClient
Public Class dbconnection
Function getConnection() As SqlConnection
Dim dbConn As SqlConnection
dbConn = New SqlConnection("Data Source=.'SQLEXPRESS;AttachDbFilename=|DataDirectory|delivery.mdf;Integrated Security=True;User Instance=True")
Return dbConn
End Function
End Class
一对一的实现如下所示:
using System.Data.SqlClient;
public class DbConnection
{
public SqlConnection getConnection()
{
SqlConnection dbConn = new SqlConnection(@"Data Source=.'SQLEXPRESS;AttachDbFilename=|DataDirectory|delivery.mdf;Integrated Security=True;User Instance=True");
return dbConn;
}
}
然而,我不能说它遵循了最佳实践。考虑实现IDisposable
以正确释放非托管资源:
using System.Data.SqlClient;
using System;
public class DbConnection : IDisposable
{
public SqlConnection DbConn { get; private set; }
public DbConnection()
{
DbConn = new SqlConnection(@"Data Source=.'SQLEXPRESS;AttachDbFilename=|DataDirectory|delivery.mdf;Integrated Security=True;User Instance=True");
}
public void Dispose()
{
if (DbConn.State != System.Data.ConnectionState.Closed) {
DbConn.Close();
}
DbConn.Dispose();
}
}
它的用法看起来像
using(DbConnection myClassInstance = new DbConnection()) {
SqlConnection connection = myClassInstance.DbConn;
}