xxxxxxxxxx
-- INIT database
CREATE TABLE Product (
ProductID INT AUTO_INCREMENT KEY,
Name VARCHAR(100),
Description VARCHAR(255)
);
INSERT INTO Product(Name, Description) VALUES ('Entity Framework Extensions', 'Use <a href="https://entityframework-extensions.net/" target="_blank">Entity Framework Extensions</a> to extend your DbContext with high-performance bulk operations.');
INSERT INTO Product(Name, Description) VALUES ('Dapper Plus', 'Use <a href="https://dapper-plus.net/" target="_blank">Dapper Plus</a> to extend your IDbConnection with high-performance bulk operations.');
INSERT INTO Product(Name, Description) VALUES ('C# Eval Expression', 'Use <a href="https://eval-expression.net/" target="_blank">C# Eval Expression</a> to compile and execute C# code at runtime.');
-- QUERY database
SELECT * FROM Product;
SELECT * FROM Product WHERE ProductID = 1
ProductID | Name | Description |
---|---|---|
1 | Entity Framework Extensions | Use Entity Framework Extensions to extend your DbContext with high-performance bulk operations. |
2 | Dapper Plus | Use Dapper Plus to extend your IDbConnection with high-performance bulk operations. |
3 | C# Eval Expression | Use C# Eval Expression to compile and execute C# code at runtime. |
ProductID | Name | Description |
---|---|---|
1 | Entity Framework Extensions | Use Entity Framework Extensions to extend your DbContext with high-performance bulk operations. |