.NET (Core and Framework)

var Violations = (from v in UnitOfWork.ViolationRepository.GetAll()
       join a in UnitOfWork.OneToManyRepository.GetAll().Where(a => a.ParentEntity == "Notice" && a.ChildEntity == "Violation")
      on v.ViolationId equals a.ChildEntityId
     join b in UnitOfWork.OneToManyRepository.GetAll().Where(a => a.ParentEntity == "Notice" && a.ChildEntity == "Case")
   on a.ParentId equals b.ParentId
  where b.ChildEntityId == caseId
  orderby v.ViolationId
  select v).ToList();

Gerry Schmitz wrote:

"Code First" is "easy";

Gerry Schmitz wrote:

it's hard when you're thinking about "conversion"

Gerry Schmitz wrote:

when still developing a data model

Gerry Schmitz wrote:

The final model drives the conversion process ("ETL"); not the other way around

Emanuela Meraglia wrote:

strange errors occur

Emanuela Meraglia wrote:

errors in the queries due to lack or incorrect formatting of dates

<pre>Private Sub AvviaServizio(ByVal t As Type, ByVal uri As String, ByVal classe As String)
        Dim binding As New BasicHttpBinding
        binding.OpenTimeout = New TimeSpan(0, 10, 0)
        binding.CloseTimeout = New TimeSpan(0, 10, 0)
        binding.SendTimeout = New TimeSpan(0, 10, 0
        'binding.ReceiveTimeout = New TimeSpan(0, 10, 0)
        'binding.Security.Mode = SecurityMode.Transport
        'binding.Security.Transport.ClientCredentialType = HttpClientCredentialType.None
        'binding.Security.Transport.ProxyCredentialType = HttpProxyCredentialType.None
        binding.MaxBufferPoolSize = 2147483647
        binding.MaxBufferSize = 2147483647
        binding.MaxReceivedMessageSize = 2147483647
        binding.MessageEncoding = WSMessageEncoding.Text

        Dim host As New ServiceModel.ServiceHost(t)
        host.AddServiceEndpoint(classe, binding, New Uri(uri & classe))
        Try
            host.Description.Behaviors.Add(New ServiceMetadataBehavior With {
                .HttpGetEnabled = True,
                .HttpGetUrl = New Uri(uri & classe)
            })
            host.Open()

            _service.Add(host)
        Catch ex As Exception
            host.Abort()
            Throw
        End Try
    End Sub

I don't understand which user you're referring to

I wrote the current user in my log file, and it matches with the Windows credentials I logged in with ... so it's ok.