Learn more about the CData ADO.NET Provider for FreshBooks or download a free trial:
Entity Framework はobject-relational mapping フレームワークで、データをオブジェクトとして扱うために使われます。Visual Studio のADO.NET Entity Data Model ウィザードを実行するとEntity Model を作成できますが、このモデルファーストアプローチでは、データソースに変更があった場合やエンティティ操作をより制御したい場合は不都合があります。この記事では、CData ADO.NET Provider を使いコードファーストアプローチでFreshBooks data にアクセスします。
To connect to FreshBooks, you can set the CompanyName and Token connection properties. Alternatively, you can use the OAuth authentication standard.
OAuth can be used to enable other users to access their own company data. To authenticate using OAuth, you will need to obtain the OAuthClientId and OAuthClientSecret by registering an app. See the "Getting Started" chapter of the help documentation for a guide to using OAuth.
<configuration>
... <connectionStrings>
<add name="FreshBooksContext" connectionString="Offline=False;CompanyName=CData;Token=token;" providerName="System.Data.CData.FreshBooks" />
</connectionStrings>
<entityFramework>
<providers>
... <provider invariantName="System.Data.CData.FreshBooks" type="System.Data.CData.FreshBooks.FreshBooksProviderServices, System.Data.CData.FreshBooks.Entities.EF6" />
</providers>
<entityFramework>
</configuration>
</code>
using System.Data.Entity;
using System.Data.Entity.Infrastructure;
using System.Data.Entity.ModelConfiguration.Conventions;
class FreshBooksContext :DbContext {
public FreshBooksContext() { }
protected override void OnModelCreating(DbModelBuilder modelBuilder) { // To remove the requests to the Migration History table
Database.SetInitializer<FreshBooksContext>(null); // To remove the plural names modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
}
}
using System.Data.Entity.ModelConfiguration;
using System.ComponentModel.DataAnnotations.Schema;
public class Clients {
[DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
public System.String Id { get; set; }
public System.String Username { get; set; }
}
public class ClientsMap :EntityTypeConfiguration<Clients> {
public ClientsMap() {
this.ToTable("Clients");
this.HasKey(Clients => Clients.Id);
this.Property(Clients => Clients.Username);
}
}
public DbSet<Clients> Clients { set; get; }
FreshBooksContext context = new FreshBooksContext();
context.Configuration.UseDatabaseNullSemantics = true;
var query = from line in context.Clients select line;