自己初学EF,发现code first这个方法可以对已有数据库进行操作，也能新建数据库，所以测试一下能否把从已知数据库里查询到的值对应地写到新的数据库里呢？代码如下图，但是这只是查询的过程，要把显示结果存储到新建数据库里该怎么办？

namespace

CodeFirstExistingDatabaseSample

{

publicclass

Program

{

staticvoid Main(string

[] args)

{

using (var db = newNorthwindContext

())

{

{

Console.Write("Enter a name for a new Product: "

);

var productname = Console

.ReadLine();

var product = newProduct

{ ProductName = productname };

db.Products.Add(product);

db.SaveChanges();

var query = (from p in

db.Products

orderby

p.ProductName.Length

select

p).ToList();

Console.WriteLine("All products in the database:"

);

foreach (var item in

query)

{

Console

.WriteLine(item.ProductName);

}

Console.WriteLine("Press any key to exit..."

);

Console

.ReadKey();

}

}

}

}

}