I want to enable the Data Sync of the selective fields only.

My main SQL Server table consists of many fields which I don't want at SQLite, becuase those are irrevelant and does not make any utilization on the mobile app.

But when I generate edmx from my existing database the entire fields code gets generated. How can I restrict that ?

Actually, you can removes the irrelevant field and keep the rest after generate edmx. Simply by open the edmx file in Visual Studio; click on the property that will be removed; and press delete button.

Also data sync is supported with Database First approach only , what if I want to use code first in EF 6.1

Synchronization feature in Crosslight depends with the architecture which is prepared in Crosslight. They are for example:

• Model must inherits from EntityBase class
  eg.:
  

  public partial class MyClass : EntityBase
  {
  
  }

• Each properties of the entities needs to be defined like following:
  

  [PrimaryKey]
  [MaxLength(128)]
  public string DeviceTokenId 
  { 
  	get { return (string)this.GetValue(DeviceTokenIdPropertyMetadata); } 
  	set { this.SetValue(DeviceTokenIdPropertyMetadata, value); } 
  }
  
  [MaxLength(128)]
  public string OperatingSystem 
  { 
  	get { return (string)this.GetValue(OperatingSystemPropertyMetadata); } 
  	set { this.SetValue(OperatingSystemPropertyMetadata, value); } 
  }

• In the Entity, after set Synchronization Date Property, a method will be created in Model controller class.
  

  public SynchronizationResult SynchronizeChanges(JObject saveBundle)
  {
      return db.SynchronizeChanges(saveBundle);
  }

• etc;

For more detail, please check the Data Synchronization documentation in here.

As long as your code first approach meet this requirements, I think it is possible to use code first with Crosslight.

Please let me know if you have other thoughts.

Hi Yudi,

Thanks for your reply.

In the same context similiar to entity am I also binded to use generated code for Web Api.  I already have existing WebApi with OData V4 which is used by my Web App. Can't I use the same without relying on generated code by CrossLight

Thanks

I'd like to confirm whether you are about to use your existing WebApi project with the code first approach data sync?

Look forward to hearing back from you.