Learn more about the CData ADO.NET Provider for Exact Online or download a free trial:
Entity Framework はobject-relational mapping フレームワークで、データをオブジェクトとして扱うために使われます。Visual Studio のADO.NET Entity Data Model ウィザードを実行するとEntity Model を作成できますが、このモデルファーストアプローチでは、データソースに変更があった場合やエンティティ操作をより制御したい場合は不都合があります。この記事では、CData ADO.NET Provider を使いコードファーストアプローチでExact Online data にアクセスします。
Exact Online uses the OAuth authentication standard. The InitiateOAuth connection property facilitates the OAuth flow -- by default, this is set to GETANDREFRESH. You can also use the embedded OAuth credentials or you can register an OAuth app with Exact to obtain your own. In addition to the OAuth values, provide the Region. If Division is not set, the default Division is determined.
See the "Getting Started" chapter of the help documentation for more information.
<configuration>
... <connectionStrings>
<add name="ExactOnlineContext" connectionString="Offline=False;Region='United States';Division=5512;" providerName="System.Data.CData.ExactOnline" />
</connectionStrings>
<entityFramework>
<providers>
... <provider invariantName="System.Data.CData.ExactOnline" type="System.Data.CData.ExactOnline.ExactOnlineProviderServices, System.Data.CData.ExactOnline.Entities.EF6" />
</providers>
<entityFramework>
</configuration>
</code>
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Data.Entity.ModelConfiguration.Conventions;
class ExactOnlineContext :DbContext {
public ExactOnlineContext() { }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { // To remove the requests to the Migration History table
Database.SetInitializer<ExactOnlineContext>(null); // To remove the plural names modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}
}
using System.Data.Entity.ModelConfiguration;
using System.ComponentModel.DataAnnotations.Schema;
public class Accounts {
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public System.String Id { get; set; }
public System.String Name { get; set; }
}
public class AccountsMap :EntityTypeConfiguration<Accounts> {
public AccountsMap() {
this.ToTable("Accounts");
this.HasKey(Accounts => Accounts.Id);
this.Property(Accounts => Accounts.Name);
}
}
public DbSet<Accounts> Accounts { set; get; }
ExactOnlineContext context = new ExactOnlineContext();
context.Configuration.UseDatabaseNullSemantics = true;
var query = from line in context.Accounts select line;