public void LookupBook( int index) { BookDetail book; using (var connection = new DatabaseConnectionProvider().GetConnection()) { SqlConnection sqlConnection = new SqlConnection("Data Source={0};Initial Catalog={1};User Id={2};Password={3}"); sqlConnection.Open(); var command = new SqlCommand { CommandType = CommandType.Text, Connection = connection, CommandText = "Select * from Books where bookid = @BookId" }; command.Parameters.AddWithValue("@BookId", index); using (var reader = command.ExecuteReader()) { book = new BookDetail { Id = reader.GetInt32(reader.GetOrdinal("Id")), Title = reader.GetString(reader.GetOrdinal("Title")), Author = new AuthorDetail { FirstName = reader.GetString(reader.GetOrdinal("FirstName")), LastName = reader.GetString(reader.GetOrdinal("LastName")) }, }; } } }
public IBookDetail FetchByIndex(int index) { DatabaseConnectionProvider connProvider = new DatabaseConnectionProvider(); FetchBookProvider bookProvider = new FetchBookProvider(new SqlResourceLoader()); BookDataManager bookDataManager = new BookDataManager(connProvider, bookProvider); return bookDataManager.FetchBookByIndex(index); }
/// <summary> /// Executes the command. /// </summary> /// <param name="arg">The arg.</param> protected static void ExecuteCommand(string arg) { var connectionProvider = new DatabaseConnectionProvider(); using (var command = connectionProvider.GetConnection().CreateCommand()) { command.CommandText = new SqlResourceLoader().LoadSqlStatement(arg); command.ExecuteNonQuery(); } }