Ninject And Connection Strings

asp.net-mvc, ioc-container, linq, ninject

Solution

You can set it up in your binding

_kernel.Bind<IProductRepository>()
       .To<SqlProductRepository>()
       .WithConstructorArgument("connectionString",yourConnectionString );

Problem

I am very new to Ninject and am trying Ninject 2 with MVC and Linq. I have a SqlProductRepository class and all I want to know is what's the best way of passing the connectionstring in the constructor if I am injecting the Repository object in the controller. ``` public class SqlProductRepository:IProductRepository { private Table<Product> productsTable; public SqlProductRepository(string connectionString) { productsTable = (new DataContext(connectionString)).GetTable<Product>(); } public IQueryable<Product> Products { get { return productsTable; } } } ``` This is my ProductController class where I am injecting the Repository: ``` public class ProductsController : Controller { private int pageSize = 4; public int PageSize { get { return pageSize; } set { pageSize = value; } } IProductRepository _productsRepository; [Inject] public ProductsController(IProductRepository productRepository) { _productsRepository = productRepository; } public ViewResult List(int page) { return View(_productsRepository.Products .Skip((page - 1) * pageSize) .Take(pageSize) .ToList() ); } } ``` Can somebody please guide me regarding this?

Original source