SqlServerEngine.cs 631 B

12345678910111213141516171819202122
  1. using System;
  2. using System.Data;
  3. using System.Data.SqlClient;
  4. namespace LJLib.DAL.SQL
  5. {
  6. internal sealed class SqlServerEngine : SqlEngine<SqlCommand>
  7. {
  8. protected override DateTime GetServerTimeInternal(SqlCommand cmd)
  9. {
  10. cmd.CommandText = "SELECT GETDATE()";
  11. cmd.CommandType = CommandType.Text;
  12. cmd.Parameters.Clear();
  13. return Convert.ToDateTime(cmd.ExecuteScalar());
  14. }
  15. protected override void AddWithValueInternal(SqlCommand cmd, string name, object value)
  16. {
  17. cmd.Parameters.AddWithValue(name, value);
  18. }
  19. }
  20. }