c# sql查是否存在某data

有Table
Customer
--ID
--Name
有srting name = "Ken";
我想查看Name是否存在name料,
如果有,就insert name(即是"Ken")到Customer的Name去

求代,麻大家!

[解决办法]
SQL方式实现

SQL code

IF(NOT EXISTS(SELECT 1 FROM [Customer] WHERE [Name] = @Name))BEGIN    INSERT INTO [Customer](Name)    SELECT @NameEND