| public static Basic ( ) : IDocumentStore | ||
| Результат | IDocumentStore | |
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
}
