using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Dynamic;
using System.Linq;
using System.Runtime.CompilerServices;
using System.Data.Linq;
using System.Data.Linq.Mapping;
using System.Xml;
using System.Runtime.Remoting.Contexts;

namespace ConsoleApp3_Test
{
    internal class Aa
    {

        static void Main(string[] args)
        {            
            DataContext dataContext = new DataContext("server=192.168.1.1,12345;database=test;uid=sa;pwd=111");
            Table<User> Users=dataContext.GetTable<User>();
            
            User query =
                (from user in Users
                 where user.name.Contains("王")
                 select user
                ).
                First();
            Console.WriteLine(query.name); 
        }
    }

    [Table (Name = "c_user")]
    public class User
    {
        [Column(Name = "userid",IsPrimaryKey =true)] public int ID;　　//此處的字段類型錯(cuò)誤，數(shù)據(jù)庫(kù)中該字段類型為varchar
        [Column (Name = "username")] public string name;
    }
 }