Databases
StackOverflow2013
Postsdbo
POFluent Validation in ASP.net MVC - Database Validations
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFluent Validation in ASP.net MVC - Database Validations
    primarykey
    data
    text
    <p>I'm using the Fluent Validation framework in my ASP.net MVC 3 project. So far all of my validations have been very simple (make sure string is not empty, only a certain length, etc.) but now I need to verify that something exists in the database or not. </p> <ol> <li>Should Fluent Validation be used in this case?</li> <li>If the database validation should be done using Fluent Validation, then how do I handle dependencies? The validator classes are created automatically, and I would need to somehow pass it one of my repository instances in order to query my database.</li> </ol> <p>An example of what I'm trying to validate might:</p> <p>I have a dropdown list on my page with a list of selected items. I want to validate that the item they selected actually exists in the database before trying to save a new record.</p> <p><strong>Edit</strong><br> Here is a code example of a regular validation in Fluent Validation framework:</p> <pre><code>[Validator(typeof(CreateProductViewModelValidator))] public class CreateProductViewModel { public string Name { get; set; } public decimal Price { get; set; } } public class CreateProductViewModelValidator : AbstractValidator&lt;CreateProductViewModel&gt; { public CreateProductViewModelValidator() { RuleFor(m =&gt; m.Name).NotEmpty(); } } </code></pre> <p>Controller:</p> <pre><code>public ActionResult Create(CreateProductViewModel model) { if(!ModelState.IsValid) { return View(model); } var product = new Product { Name = model.Name, Price = model.Price }; repository.AddProduct(product); return RedirectToAction("Index"); } </code></pre> <p>As you can see, I never create the Validator myself. This works because of the following line in <code>Global.asax</code>:</p> <pre><code>FluentValidation.Mvc.FluentValidationModelValidatorProvider.Configure(); </code></pre> <p>The problem is that now I have a validator that needs to interact with my database using a repository, but since I'm not creating the validators I don't know how I would get that dependency passed in, other than hardcoding the concrete type.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USDismissile
    1. USDismissile
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. USDismissile
      1. VTBountyStart
    1. COI added an example hot to use the session Dependency injection in your validations. Hope it will help. P.S. No need for bounty just say you need an example...
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. USgdoron
    2. COExcept that your example is not giving me what I ask for. I told you already that I don't create the validator myself. It is created by the Fluent Validation framework automatically. FluentValidation needs a default parameterless constructor or it will fail to create the validator.
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. USDismissile
    3. COupdated, You will have to use an IoC container to inject the Session object outside the constructor.
      singulars
      1. POFluent Validation in ASP.net MVC - Database Validations
      1. USgdoron
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload