.NETѧϰÊÖ¼ÇÖ®£ºlinq to SQL(Ò»)
Ò»¸ö¼òµ¥µÄÀý×Ó£º
ÏȽ¨Ò»¸öC#Àࣺ
ÒýÓÃSystem.Data.Linq.dll³ÌÐò¼¯£¬
using System.Data.Linq.MappingºÍ
using System.Data.Linq Á½¸ö¿Õ¼ä¡£
[Table]
public class Inventory
{
[Column]
public string Make;
[Column]
public string Color;
[Column]
public string PetName;
//Ö¸Ã÷Ö÷¼ü¡£
[Column(IsPrimaryKey = true)]
public int CarID;
public override string ToString()
{
return string.Format(
"±àºÅ={0};ÖÆÔìÉÌ={1};ÑÕÉ«={2};°®³Æ={3}",
CarID,Make.Trim(),Color.Trim(),PetName.Trim());
}
}
ÓëSQL(express°æ)Êý¾Ý¿â½»»¥:
class Program
{
const string cnStr=
@"Data Source=(local)\SQLEXPRESS;Initial Catalog=Autolot;"+
"Integrated Security=True";
static void Main(string[] args)
{
Console.WriteLine("*****LINQ to SQL ¼òµ¥Ó¦ÓÃ*****");
//´´½¨Ò»¸öDataContext¶ÔÏó¡£
DataContext db= new DataContext(cnStr);
//´´½¨Ò»¸öTable<>·ºÐÍʵÀý¡£
Table<Inventory> invTable = db.GetTable<Inventory>();
//ÓÃÒ»¸öLINQ²éѯÏÔʾ½á¹û¡£
foreach(var car in from c in invTable select c)
Console.WriteLine(car.ToString());
}
Console.ReadLine();
}
¶ÔDataContextÀà½øÐÐÀ©Õ¹£º
class MyAutoLotDatabase:DataContext
{
public Table<Inventory> Inventory;
public MyAut
Ïà¹ØÎĵµ£º
±È½ÏÁ½¸öSQLµÄÖ´ÐÐʱ¼ä
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PROC_SQL_COMP]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[PROC_SQL_COMP]
GO
/*--²âÊÔÁ½×éSQLµÄƽ¾ùʱ¼ä
ÀûÓÃosql.exeÀ´²âÊÔÁ½×é SQL Óï¾äµÄÖ´ÐÐʱ¼ä
²âÊԵĴ洢¹ý³ ......
PL/SQLʵÀý·ÖÎö
µÚÎåÕÂ
1¡¢PL/SQLʵÀý·ÖÎö
1£©ÔÚ¡¾SQLPlus Worksheet¡¿ÖÐÖ±½ÓÖ´ÐÐÈçÏÂSQL´úÂëÍê³ÉÉÏÊö²Ù×÷¡£(´´½¨±í)
¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D¨D
CREATE TABLE "SCOTT"."TESTTABLE" ("RECORDNUMBER" NUMBER(4) NOT NULL, "CURRENTDATE" DATE NOT NULL)
TABLESPACE "SYSTEM ......
...
)
Óõ½µÄ¹¦ÄÜÓÐ:
1.Èç¹ûÎÒ¸ü¸ÄÁËѧÉúµÄѧºÅ,ÎÒÏ£ÍûËûµÄ½èÊé¼Ç¼ÈÔÈ»ÓëÕâ¸öѧÉúÏà¹Ø(Ò²¾ÍÊÇͬʱ¸ü¸Ä½èÊé¼Ç¼±íµÄѧºÅ);
2.Èç¹û¸ÃѧÉúÒѾ ......