What is VB.net equivalent

.NET
1

Hi, what is vb.net equivalent for the following? Thanks

C#


using (UtilityDataContext context = new UtilityDataContext())
            {
                L2SSiteSetting result = context.L2SSiteSettings.SingleOrDefault(x => x.SettingId == id);
                if (result != null)
                {
                    setting = new SiteSetting {
                                      CreatedDate = result.CreatedDate == null ? new DateTime() : Convert.ToDateTime(result.CreatedDate),
                                      IsActive = result.IsActive != null && Convert.ToBoolean(result.IsActive),
                                      ModifiedDate = result.ModifiedDate == null ? new DateTime() : Convert.ToDateTime(result.ModifiedDate),
                                      SettingId = result.SettingId,
                                      SettingTypeId = result.SettingTypeId,
                                      SettingValue = result.SettingValue
                                  };
                }
            }
2

Using context As New UtilityDataContext()
Dim result As L2SSiteSetting = context.L2SSiteSettings.SingleOrDefault(Function(x) x.SettingId = id)
If result IsNot Nothing Then
setting = New SiteSetting() With { _
Key .CreatedDate = If(result.CreatedDate Is Nothing, New DateTime(), Convert.ToDateTime(result.CreatedDate)), _
Key .IsActive = result.IsActive IsNot Nothing AndAlso Convert.ToBoolean(result.IsActive), _
Key .ModifiedDate = If(result.ModifiedDate Is Nothing, New DateTime(), Convert.ToDateTime(result.ModifiedDate)), _
Key .SettingId = result.SettingId, _
Key .SettingTypeId = result.SettingTypeId, _
Key .SettingValue = result.SettingValue _
}
End If
End Using

3

Thanks.