Hi The problem is that the FTS-index it is not updated yet, it takes a few seconds (2 or 3). Add a delay to see the behaviour with Thread.Sleep(...).
The best way is to add a query asking for the Populate State. See the property FULLTEXTCATALOGPROPERTY. Cheers. On Sat, Aug 29, 2009 at 11:07 PM, Darryl Parker <[email protected]> wrote: > > I'm stumped. I have a simple object called Listing with two string > properties: Title and Description. I also have a guid Id. This > object and it's properties map to a SQL Server 2008 database. I also > have a full-text index on the Description field. All of my CRUD > persistence tests pass with the exception of full-text query tests. > Here is my simple full-text query method: > > public Listing[] GetByFTS(string searchString){ > > return GetSession().CreateSQLQuery("SELECT * FROM dbo.Listings > WHERE > FREETEXT ([Description], :searchString, LANGUAGE > 1033);","listings", > typeof(Listing)).SetString("searchString", > searchString).List<Listing>().ToArray(); > } > > By the way, this method works fine when I connect it to a controller > and view. But if fails when I try to do an integration test. The > following integration test ought to pass but it fails saying "Expected > 1 But was 0". > > [Test] > public void Full_Text_Search_Test() > { > Listing listing = new Listing() { Title = "My new > listing", Description = "It is time for all good men to come to the > aid of their country." }; > > PersistEntity(listing); > > IListingRepository repository = new ListingRepository(new > HybridSessionBuilder()); > Listing[] listings = repository.GetByFTS("men"); > > Assert.That(listings.Length, Is.EqualTo(1)); > > } > > The strange thing is, when I set a break point and run this test with > the debugger and step through it, the test passes! It is only when I > run the test normally that it fails to retrive the record I just > added. > > Any ideas? > > > > > > > -- Dario Quintana http://darioquintana.com.ar --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
