<div>
@prabhu rajendra's solution was well received, totally accurate and solved our problem.
</div>


@prabhu rajendra's solution was well received, totally accurate and solved our problem.

<div>
<div class="content wysiwyg-content">
How do we implement this SQL Server syntax<br />
<br />
IF(SELECT MAX(DateAdded) FROM RestoreDetectors &quot;&nbsp;+<br />
&quot;&nbsp;WHERE CONVERT(VARCHAR,DateAdded,<wbr />101) = CONVERT(VARCHAR,GETDATE(),<wbr /> 101) &quot;&nbsp;+<br />
&quot;&nbsp;AND DATEDIFF(SECOND, DateAdded,GETDATE()) &lt;= {0}) IS NULL&quot;<br />
<br />
in Mono- .NET 4.5 C# MySql.Data.MySqlClient version 5.6: <br />
<br />
<br />
any help is greatly appreciated
</div>
</div>


How do we implement this SQL Server syntax

IF(SELECT MAX(DateAdded) FROM RestoreDetectors " +
" WHERE CONVERT(VARCHAR,DateAdded,101) = CONVERT(VARCHAR,GETDATE(), 101) " +
" AND DATEDIFF(SECOND, DateAdded,GETDATE()) <= {0}) IS NULL"

in Mono- .NET 4.5 C# MySql.Data.MySqlClient version 5.6: 


any help is greatly appreciated

How do we implement SQL Server IF ( SELECT in MySQL 5.6?

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.

Linux

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Mono is an open source platform based on the .NET framework to enable the development of Linux and other cross-platform applications. Based on C# and the Common Language Infrastructure (CLI) standards, applications can also be developed in VB.NET, Java, Python, F#, Ruby, Eiffel and others, and includes a Microsoft compatible API.