Velocity supports a number of mechanism for retrieving and inserting data, the most common being: - [AddRecord](https://yndigoblue.com/documentation/velocity/latest/api/YndigoBlue.Velocity.Engine.Manager.AddRecord.html) - [Retreive](https://yndigoblue.com/documentation/velocity/latest/api/YndigoBlue.Velocity.Engine.Manager.Retrieve.html#YndigoBlue_Velocity_Engine_Manager_Retrieve_YndigoBlue_Velocity_Model_Query_) - [Search](https://yndigoblue.com/documentation/velocity/latest/api/YndigoBlue.Velocity.Engine.Manager.Search.html) While these methods are powerful in their own right they tend to result in code that's often too verbose. Data binding allows for code that's much more concise in nature. ### Adding Data For this example let's use a simple table, defined here in Velocity's XML format. ``` customer_id email first_name last_name confirmed creation_stamp subscription_active total_licenses join_date

``` With this table configuration, adding data can be done using the standard mechanism as follows. ``` using var m = new Manager(datasourceConnection); var t = schema["customer"]; var r = new Record(t); r.SetColumnVarChar("email", "john.smith@gmail.com"); r.SetColumnVarChar("first_name", "john"); r.SetColumnVarChar("last_name", "smith"); r.SetColumnBoolean("confirmed", true); r.SetColumnDateTime("creation_stamp", DateTime.Now); r.SetColumnBoolean("subscription_active", true); r.SetColumnInteger("total_licenses", 5); r.SetColumnDate("join_date", DateOnly.Now); long customerId = m.AddRecord(r); ``` Scaling this up can result in a lot of code, especially if the values are being loaded from objects. Now let's look at how data binding can make this simpler. ``` class Customer { public long CustomerId { get; set; } public string Email{ get; set; } public sting FirstName { get; set; } public sting LastName { get; set; } public bool? Confirmed { get; set; } public DateTime? CreationStamp { get; set; } public bool SubscriptionActive { get; set; } public int TotalLicenses { get; set; } public DateOnly? JoinDate { get; set; } } var c = new Customer { Email = "john.smith@gmail.com", FirstName = "john", r.SetColumnVarChar("last_name", "smith"); r.SetColumnBoolean("confirmed", true); r.SetColumnDateTime("creation_stamp", DateTime.Now); r.SetColumnBoolean("subscription_active", true); r.SetColumnInteger("total_licenses", 5); r.SetColumnDate("join_date", DateOnly.Now); } Record r = new Record(t, BindingType.SnakeCase); record.Bind(user); ```

Data Binding Made Easy