Load the Data through LoadbyprimaryKey() then save the Data. I get the following error on

System.Data.SQLClient.SqlException: Incorrect syntax near 'TSEQUAL'
at EntitySpaces.Core.esEntityCollection.SaveToProviserInsertsUpdates(esSqlAccessType sqlAccessType)
at EntitySpaces.Core.esEntityCollection.SaveToProvider(esSqlAccessType sqlAccessType)
at EntitySpaces.Core.esEntityCollection.Save(esSqlAccessType sqlAccessType)
at EntitySpaces.Core.esEntityCollection.Save()
at Frm_Patient.Save()

I am doing windows application.

Please provide the solution for that.

Some quick possibilities:

If you are using stored procedures, there is a check box on the template if you are targeting SQL Server 2005.

See the "Getting Started" config section. This line must match "2000" or "2005".

databaseVersion="2005"