用LINQ在SQL中保存图片路径

CREATE TABLE Images (
    Id INT PRIMARY KEY,
    Path VARCHAR(255)
);

string connectionString = "Data Source=server;Initial Catalog=database;User ID=username;Password=password;";
SqlConnection connection = new SqlConnection(connectionString);

DataContext context = new DataContext(connection);

[Table(Name = "Images")]
public class Image
{
    [Column(IsPrimaryKey = true)]
    public int Id { get; set; }
    
    [Column]
    public string Path { get; set; }
}

Image image = new Image { Id = 1, Path = "image.jpg" };
context.GetTable<Image>().InsertOnSubmit(image);
context.SubmitChanges();

var images = from image in context.GetTable<Image>()
             select image;

Image image = context.GetTable<Image>().FirstOrDefault(i => i.Id == 1);
if (image != null)
{
    image.Path = "new_image.jpg";
    context.SubmitChanges();
}

Image image = context.GetTable<Image>().FirstOrDefault(i => i.Id == 1);
if (image != null)
{
    context.GetTable<Image>().DeleteOnSubmit(image);
    context.SubmitChanges();
}