// Create a new SqlDatabase instance SqlDatabase db = new SqlDatabase("Data Source=myServer;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword"); // Define a SQL query to select data from a table string query = "SELECT * FROM Customers"; // Execute the query and return the results as a DataSet DataSet results = db.ExecuteDataSet(CommandType.Text, query); // Loop over the rows in the results and print them out foreach (DataRow row in results.Tables[0].Rows) { Console.WriteLine("Customer ID: {0}, Name: {1}, Email: {2}", row["CustomerId"], row["Name"], row["Email"]); }
// Create a new SqlDatabase instance SqlDatabase db = new SqlDatabase("Data Source=myServer;Initial Catalog=myDatabase;User ID=myUsername;Password=myPassword"); // Define the name of the stored procedure string procedureName = "InsertCustomer"; // Create a new Database object to hold the parameters for the stored procedure Database dbParams = db.CreateDatabase(); // Add the parameters for the stored procedure dbParams.AddInParameter("Name", DbType.String, "John Smith"); dbParams.AddInParameter("Email", DbType.String, "[email protected]"); // Execute the stored procedure int rowsAffected = db.ExecuteNonQuery(procedureName, dbParams); // Print out the number of rows affected by the query Console.WriteLine("{0} rows inserted", rowsAffected);In summary, Microsoft.Practices.EnterpriseLibrary.Data.Sql is a package library for C# developers that provides classes and methods for accessing SQL Server databases. The SqlDatabase class is used to establish a connection to a database and execute queries or stored procedures.