Bilietai i build stuff

https://www.eventbrite.com/e/software-development-conference-build-stuff-2016-lithuania-tickets-19886732753

http://www.infoq.com - sudeti irasai is 2015 m konferencijos

LINQ transactions

odb.Connection.Open()
            odb.Transaction = odb.Connection.BeginTransaction()
            Try
  odb.procedureA(1)
                odb.procedureB(2)
                odb.procedureC(3)
                odb.procedureD(4)
                  
                odb.Transaction.Commit()
            Catch ex As Exception
                WebEmail.SendExceptionEmail("dsk@abc.lt", "CRC deadlock", Server.GetLastError)
                odb.Transaction.Rollback()
                ScriptManager.RegisterStartupScript(Me, Me.GetType, "CloseD", "alert('An error occurred. Please do not close window and try again after 5 minutes!');", True)
            Finally
                odb.Connection.Close()
            End Try




Su odb.SubmitChanges - tinka tik mazom operacijom
Kai distributed užklausos, geriau dirbti su transactionScope

MS SQL: LIKE

Problema:


Neveikia LIKE '%Dovilė%'






Sprendimas:


Reikia nurodyti, kad naudosime unicode LIKE N'%Dovilė%'


Tas pats su = ir <>