mono中有操作sqlserver的相关dll,可以直接引用。下面例子共参考: using System; using System.Data; using System.Data.SqlClient; public class Test { public static void Main(string[] args) { string connectionString = "Server=local;" + "Database=pubs;" + "User ID=UserName;" + "assword=Password;"; IDbConnection dbcon; using (dbcon = new SqlConnection(connectionString)) { dbcon.Open(); using (IDbCommand dbcmd = dbcon.CreateCommand()) { string sql = "SELECT fname, lname " + "FROM employee"; dbcmd.CommandText = sql; using (IDataReader reader = dbcmd.ExecuteReader()) { while(reader.Read()) { string FirstName = (string) reader["fname"]; string LastName = (string) reader["lname"]; Console.WriteLine("Name: " + FirstName + " " + LastName); } } } } } } |
|