Learn more about the CData ADO.NET Provider for MarkLogic or download a free trial:
Entity Framework はobject-relational mapping フレームワークで、データをオブジェクトとして扱うために使われます。Visual Studio のADO.NET Entity Data Model ウィザードを実行するとEntity Model を作成できますが、このモデルファーストアプローチでは、データソースに変更があった場合やエンティティ操作をより制御したい場合は不都合があります。この記事では、CData ADO.NET Provider を使いコードファーストアプローチでMarkLogic data にアクセスします。
Set User, Password, and Server to the credentials for the MarkLogic account and the address of the server you want to connect to. You should also specify the REST API Port if you want to use a specific instance of a REST Server.
<configuration>
... <connectionStrings>
<add name="MarkLogicContext" connectionString="Offline=False;User='myusername';Password='mypassword';Server='http://marklogic';" providerName="System.Data.CData.MarkLogic" />
</connectionStrings>
<entityFramework>
<providers>
... <provider invariantName="System.Data.CData.MarkLogic" type="System.Data.CData.MarkLogic.MarkLogicProviderServices, System.Data.CData.MarkLogic.Entities.EF6" />
</providers>
<entityFramework>
</configuration>
</code>
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Data.Entity.ModelConfiguration.Conventions;
class MarkLogicContext :DbContext {
public MarkLogicContext() { }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { // To remove the requests to the Migration History table
Database.SetInitializer<MarkLogicContext>(null); // To remove the plural names modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}
}
using System.Data.Entity.ModelConfiguration;
using System.ComponentModel.DataAnnotations.Schema;
public class Customer {
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public System.String Id { get; set; }
public System.String Name { get; set; }
}
public class CustomerMap :EntityTypeConfiguration<Customer> {
public CustomerMap() {
this.ToTable("Customer");
this.HasKey(Customer => Customer.Id);
this.Property(Customer => Customer.Name);
}
}
public DbSet<Customer> Customer { set; get; }
MarkLogicContext context = new MarkLogicContext();
context.Configuration.UseDatabaseNullSemantics = true;
var query = from line in context.Customer select line;