using System.Data.SqlClient; string connectionString = "Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUsername;Password=myPassword"; SqlConnection connection = new SqlConnection(connectionString); try { connection.Open(); Console.WriteLine("Connection successful!"); } catch (Exception ex) { Console.WriteLine("Connection failed: " + ex.Message); } finally { connection.Close(); }
using System.Linq; using MyProject.Models; var dbContext = new MyDbContext(); var people = dbContext.People.Where(p => p.Age > 30); foreach (var person in people) { Console.WriteLine(person.Name); }In this example, we are using Entity Framework to retrieve all people from the database whose age is greater than 30. We are then iterating over the resulting collection and printing out each person's name. Overall, there are many database libraries available for C#, and developers should choose the one that best fits their needs and preferences. ADO.NET and Entity Framework are just two examples of popular libraries that can help developers work with databases more efficiently and effectively.