public void read_as_text_reader() { using (var store = TestingDocumentStore.Basic()) { var target = Target.Random(true); using (var session = store.OpenSession()) { session.Store(target); session.SaveChanges(); } using (var conn = store.Advanced.OpenConnection()) { var json = conn.Execute(cmd => { using (var reader = cmd.Sql("select data from mt_doc_target").ExecuteReader()) { reader.Read(); return(reader.GetTextReader(0).ReadToEnd()); } }); Console.WriteLine(json); } } }
public void can_generate_a_computed_index() { using (var store = TestingDocumentStore.Basic()) { store.Schema.EnsureStorageExists(typeof(User)); var mapping = store.Schema.MappingFor(typeof(User)); var sql = mapping.As <DocumentMapping>().FieldFor(nameof(User.UserName)).As <JsonLocatorField>().ToComputedIndex(mapping.Table) .Replace("d.data", "data"); using (var conn = store.Advanced.OpenConnection()) { conn.Execute(cmd => cmd.Sql(sql).ExecuteNonQuery()); } using (var session = store.OpenSession()) { var query = session.Query <User>() .Where(x => x.UserName == "hank") .ToCommand(FetchType.FetchMany) .CommandText; _output.WriteLine(query); var plan = session.Query <User>().Where(x => x.UserName == "hank").Explain(); _output.WriteLine(plan.ToString()); } } }
protected IntegratedFixture(ITestOutputHelper output = null) { _output = output; _store = new Lazy <IDocumentStore>(() => TestingDocumentStore.Basic(EnableCommandLogging ? _output : null)); if (GetType().GetTypeInfo().GetCustomAttribute <CollectionAttribute>(true) != null) { UseDefaultSchema(); } #if NET46 _originalCulture = Thread.CurrentThread.CurrentCulture; Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US"); Thread.CurrentThread.CurrentUICulture = new CultureInfo("en-US"); #endif }