LINQ to SQL ÔÚ Visual Studio 2008 Öеļòµ¥Ó¦ÓÃ
ÔÚ.Net Framework 3.5 ÖУ¬×¶¯ÈËÐĵľÍÊÇÔö¼ÓÁËLINQ¹¦ÄÜ£¬LINQÔÚÊý¾Ý¼¯³ÉµÄ»ù´¡ÉÏÌṩÁËеÄÇáÐÍ·½Ê½¡£ÓÐÁËLINQ£¬ÎÒÃÇ´´½¨µÄ²éѯÏÖÔھͱà³ÌÁË.Net ¿ò¼ÜµÄÒ»¸ö³ÉÔ±£¬ÔÚ¶ÔÒª²Ù×÷µÄÊý¾Ý´æ´¢Ö´Ðвéѯʱ£¬»áºÜ¿ì·¢ÏÖËûÃÇÏÖÔڵIJÙ×÷·½Ê½ÀàËÆÓÚϵͳÖеÄÀàÐÍ¡£Õâ˵Ã÷£¬ÏÖÔÚ¿ÉÒÔʹÓÃÈÎÒâ¼æÈÝ.Net µÄÓïÑÔÀ´²éѯµ×²ãµÄÊý¾Ý´æ´¢£¬ÕâÔÚÒÔǰÊDz»¿ÉÄܵġ£
¸ù¾ÝÒªÔÚÓ¦ÓóÌÐòÖд¦ÀíµÄµ×²ãÊý¾ÝµÄ²»Í¬£¬Óв»Í¬ÀàÐ͵ÄLINQ¹¦ÄÜ£º
LINQ to Objects
¶ÔÏóÖ»²»¹ýÊÇ´æ´¢ÔÚÄÚ´æÖеÄÊý¾Ý£¬¶ÔÏó±¾Éí¿ÉÄܾÍÊDzéѯÊý¾Ý£¬´Ëʱ¿ÉÒÔʹÓÃLINQ to Objects
LINQ to SQL¡¢LINQ to DataSets ºÍ LINQ to Entities ÌṩÁ˲éѯ¹ØÏµÐÍÊý¾ÝµÄ·½Ê½£¬Ö±½Ó·ÃÎÊÊý¾ÝºÍ´æ´¢¹ý³Ì£¬¼°±íʾ±íʾÌåÖ®¼äµÄ¹ØÏµ£¬Ö´ÐÐÌíɾ¸Ä²é¡£
LINQ to XML
LINQ to SQL ºÍ Visual Studio 2008
LINQ to SQL ÊÇÔÚSQL Server Êý¾Ý¿âÉÏÉèÖÃÒ»¸öÇ¿ÀàÐÍ»¯½çÃæµÄ·½Ê½£¬ÌṩÁËĿǰ²éѯSQL Server ×î¼òµ¥µÄ·½·¨¡£
ÏÂÃæÒª´´½¨Ò»¸öʾÀý£¬´ÓNorthwindÊý¾Ý¿â£¨SQL Server 2000 ʾÀýÊý¾Ý¿â ÏÖÔÚÖ»Äܵ½ÍøÉÏËÑË÷ÏÂÔØÁË£©µÄProducts ±íÖÐÌáÈ¡Êý¾ÝÏî
Ò»£¬ÓÃVSTS 2008 н¨Ò»¸öC# Web Ó¦ÓóÌÐò£¨.Net 3.5£©
¶þ£¬ÓÒ¼üΪÏîÄ¿Ìí¼ÓÒ»¸öLINQ to SQL Àà ²¢ÎªÆäÃüÃûΪºÍÊý¾Ý¿âÏàͬµÄÃû×Ö£¬ÈÝÒ×ʶ±ð¡£
È·¶¨£¬½á¹ûÈçÏ£¬¿É¼ûORÉè¼ÆÆ÷±»´ò¿ª
ORÉè¼ÆÆ÷ÓÉÁ½²¿·Ö×é³É£º
×ó±ß²¿·ÖÓÃÓÚÏÔʾÊý¾ÝÀ࣬Ëü¿ÉÒÔÊÇ±í¡¢Àà¡¢¹ØÁªºÍ¼Ì³Ð¡£
Óұ߲¿·ÖÓÃÓÚÏÔʾ·½·¨£¬ÕâЩ·½·¨Ó³Éäµ½Êý¾Ý¿âÖеĴ洢¹ý³ÌÉÏ¡£
Èý£¬´´½¨±í¶ÔÏó
ÔÚ´´½¨±í¶ÔÏó֮ǰ£¬ÎÒÃÇÏÈÓ÷þÎñÆ÷×ÊÔ´¹ÜÀíÆ÷½¨Á¢¶ÔNorthwindÊý¾Ý¿âµÄÒýÓá£
ÓÒ¼üÊý¾ÝÁ¬½Ó½Úµã->Ìí¼ÓÁ¬½Ó£¬´ò¿ªÌí¼ÓÁ¬½Ó¶Ô»°¿ò
ÊäÈë·þÎñÆ÷Ãû£¬ÃÜÂ룬²¢Ñ¡ÔñÊý¾Ý¿âÖ®ºóµãÈ·¶¨°´Å¥¡£Êý¾Ý¿â±»Ìí¼ÓÁ˽øÀ´¡£
´ò¿ª´ËÊý¾Ý¿âµÄ±íÎļþ¼Ð£¬Ñ¡ÔñProduct ±íÓÃÊó±êÖ±½ÓÍ϶¯µ½ORÉè¼ÆÆ÷ÉÏ£¬½á¹ûÈçÏÂ
ͬʱWeb.Config ÎļþÖлáÌí¼ÓÈçϵÄÁ¬½ÓÐÅÏ¢£¬ÔÚNorthwind.designer.csÎļþÖл¹»áÌí¼ÓÏàÓ¦µÄÓ³ÉäÉè¼Æ´úÂë
<connectionStrings>
<add name="NorthwindConnectionString" connectionString="Data Source=TERRYFENG-PC;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=saaaaa"
providerName="System.Data.SqlClient" />
</connectionStrings>
ÔÚORÉè¼ÆÆ÷µÄÊôÐÔ´°¿ÚÖУ¬ÎÒÃÇ¿ÉÒÔ¿´µ½Á¬½Ó´®µÈÐÅÏ¢
´ò¿ªDefault.aspx Îļþ£¬ÏòÆäÖÐÍ϶¯Ò»¸öGridView ¿Ø¼þ£¬²¢ÔÚºó
Ïà¹ØÎĵµ£º
ÔÚSQL ServerÖУ¬Èç¹û°Ñ±íµÄÖ÷¼üÉèΪidentityÀàÐÍ£¬Êý¾Ý¿â¾Í»á×Ô¶¯ÎªÖ÷¼ü¸³Öµ¡£ÀýÈ磺
create table customers (
id int identity(1,1) primary key not null,
name varchar(15)
);
insert into customers(name) values("name1"),("name2");
select id from customers;
²éѯ½á¹ûΪ£º
id
---
1
2
ÓÉ´Ë¿ ......
½¨Á¢±í£º
CREATE TABLE [TestTable] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[FirstName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[LastName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[Country] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Note] [ ......
Oracle SQL PLUS »ù±¾²Ù×÷1
怬
c:\>sqlplus "sys/test1234 as sysdba" ÒÔsysdbaÉí·ÝµÇ¼
c:\>sqlplus/nolog ÒÔnologÉí·ÝµÇ¼
sql> connect sys/test1234 as sysdba
Connected.
Æô¶¯
SQL> startup &nb ......
²»´íµÄ×ÊÁÏ,ת¹ýÀ´,·½±ãÈÕºó²é¿´Ê¹ÓÃ!!!
--¼à¿ØË÷ÒýÊÇ·ñʹÓÃ
alter index &index_name monitoring usage;
alter index &index_name nomonitoring usage;
select * from v$object_usage where index_name =
&index_name;
--ÇóÊý¾ÝÎļþµÄI/O·Ö²¼
select
df.name,phyrds,phywrts,phyblkrd,phyblkwrt,sin ......
SQLµÄÓÅ»¯Ó¦¸Ã´Ó5¸ö·½Ãæ½øÐе÷Õû£º
1.È¥µô²»±ØÒªµÄ´óÐͱíµÄÈ«±íɨÃè
2.»º´æÐ¡ÐͱíµÄÈ«±íɨÃè
3.¼ìÑéÓÅ»¯Ë÷ÒýµÄʹÓÃ
4.¼ìÑéÓÅ»¯µÄÁ¬½Ó¼¼Êõ
5.¾¡¿ÉÄܼõÉÙÖ´Ðмƻ®µÄCost
SQLÓï¾ä£º
ÊǶÔÊý¾Ý¿â(Êý¾Ý)½øÐвÙ×÷µÄΩһ;¾¶£»
ÏûºÄÁË70%~90%µÄÊý¾Ý¿â×ÊÔ´£»¶ÀÁ¢ÓÚ³ÌÐòÉè¼ÆÂß¼£¬Ïà¶ÔÓÚ¶Ô³ÌÐòÔ´´úÂëµÄÓÅ»¯£¬¶ÔSQLÓï¾äµÄÓÅ»¯Ô ......