title: How to store lucene index data to database instead of file
body: <p>lucene.net always store index data in flat file like this way.....here is sample code which create index and store index data in flat file.</p>
  
  <pre><code>String sql = "select id, firstname, lastname, phone, email from person";
  ResultSet rs = stmt.executeQuery(sql);
  while (rs.next()) {
      Document doc = new Document();
      doc.add(new Field("id", rs,getString("id"), Field.Store.YES, Field.Index.UN_TOKENIZED));
      doc.add(new Field("firstname", rs,getString("firstname"), Field.Store.YES, Field.Index.TOKENIZED));  
      // ... repeat for each column in result set
      writer.addDocument(doc);
  }
  </code></pre>
  
  <p>so just guide me how i can store lucene.net index data to sql server table instead of flat file....is it possible....if yes then guide me. thanks</p>