using System.EnterpriseServices;
[Transaction(TransactionOption.Required)]
public class StudentService : ServicedComponent
{
private readonly string connString =
System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
[AutoComplete]
public void AddStudent()
{
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(connString);
System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into student(name,age) values(@name,@age)";
try
{
cmd.Parameters.AddWithValue("@name", "张三");
cmd.Parameters.AddWithValue("@age", "20");
conn.Open();
cmd.ExecuteNonQuery();
}
finally
{
conn.Close();
}
}
}