Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

×ß½øLinq Linq to SQLÔ´´úÂëÉÍÎö

ÔÚDataContextÖÐÎÒÃÇ´ò½»µÀ×î¶àµÄÒ²Ðí¾ÍÊÇGetTable<TEntity>()·½·¨ÁË£¬Õâ¸ö·½·¨»á»ñÈ¡Ò»¸öTable<TEntity>¶ÔÏ󣬽ñÌìÎÒÃǾÍÀ´¿´¿´Õâ¸ö¶ÔÏóÊÇÈçºÎ»ñÈ¡µÄ¡£
¡¡¡¡¶ÔÓÚ»ñÈ¡Table<TEntity>¶ÔÏóÎÒÃÇ»¹Òª¿´¿´Õâ¸öDataContextÊDz»ÊÇÇ¿ÀàÐ͵ģ¬¹ØÓÚÇ¿ÀàÐ͵ÄDataContext¿ÉÒÔ¿´ÎÒÇ°ÃæһƪÎÄÕ£¬Ç¿ÀàÐ͵ÄDataContextÀï°üº¬Óм¸¸öTable<TEntity>ÀàÐ͵ÄÊôÐÔ£¬±ÈÈçÎÒÃǵĿâÖÐÓÐblogs¡¢postsµÈÊý¾Ý
¿â±í£¬ÄÇôÄã¿ÉÄܾͻὨÁ¢Table<Blog>ºÍTable<Post>ÀàÐ͵ÄÊôÐÔ£¨²Î¼ûÇ°ÃæһƪÎÄÕ£©¡£ÔÚÉÏÒ»ÕÂDataContextµÄ³õʼ»¯Àï½²µ½Init·½·¨µÄ×îºóÒ»ÐÐÊÇInitTables·½·¨µÄµ÷Óá£ÎÒÃÇÊ×ÏÈÀ´¿´¿´InitTables·½·¨µÄ´úÂ룺
///<summary>
///³õʼ»¯Êý¾Ý¿âÖÐÓм¸¸ö±í
///´Ó·½·¨ÊµÏÖÖÐÒâͼÀ´¿´£¬Õâ¸ö·½·¨Ö÷ÒªÔÚ¶¨ÒåÁËÇ¿ÀàÐ͵ÄDataContext²ÅÓÐÒâÒå
///ÔÚÇ¿ÀàÐ͵ÄDataContextÀïÒ»°ã¶¨ÒåÁËTable<Post>Ö®ÀàµÄ×Ö¶ÎÀ´±íʾÊý¾Ý¿âÖÐÓм¸¸ö
///±í£¬¸Ã·½·¨µ÷ÓÃDataContextµÄGetTable·½·¨ÉèÖÃÕâЩ×ֶεÄÖµ
///</summary>
///<paramname="schema"></param>
private void InitTables(objectschema)
{
¡¡¡¡//Ó÷´Éä±éÀúDataContextÀࣨ¿ÉÄÜÊÇËüµÄ×ÓÀࣩÀïËùÓеĹ«ÓÐʵÀý×Ö¶Î
¡¡¡¡¡¡foreach(FieldInfo info in schema.GetType().GetFields(BindingFlags.Public|BindingFlags.Instance))
¡¡¡¡{
¡¡¡¡¡¡¡¡//×Ö¶ÎÀàÐÍ
¡¡¡¡¡¡¡¡Type fieldType=info.FieldType;
¡¡¡¡¡¡¡¡//¸Ã×Ö¶ÎÊÇ·ñÊÇ·ºÐ͵ģ¬²¢ÇÒÊÇTable<>ÀàÐ͵ģ¬¶øÇÒ¸Ã×ֶεÄֵΪnull
¡¡¡¡¡¡¡¡if((fieldType.IsGenericType&&(fieldType.GetGenericTypeDefinition()==
¡¡¡¡¡¡¡¡¡¡¡¡typeof(Table<>)))&&(((ITable)info.GetValue(schema))==null))
¡¡¡¡¡¡¡¡{
¡¡¡¡¡¡¡¡¡¡¡¡¡¡//»ñÈ¡Table<TEntity>ÖÐTEntityµÄ¾ßÌåÀàÐÍ
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡Typetype=fieldType.GetGenericArguments()[0];
¡¡¡¡¡¡¡¡¡¡¡¡¡¡//µ÷ÓÃDataContextµÄGetTable·½·¨µÃµ½Ò»¸öITable¶ÔÏó
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ITable table=this.GetTable(type);
¡¡¡¡¡¡¡¡¡¡¡¡¡¡//ÉèÖÃÖµ
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡info.SetValue(schema,table);
¡¡¡¡¡¡¡¡¡¡}
¡¡¡¡¡¡¡¡}
}
´úÂëÖеÄ×¢ÊÍ˵µÄºÜÏêϸÁË£¬ÏÈ¿´¿´DataContextÀàÀïÊÇ·ñÓÐTable<TEntity>µÄÊôÐÔ£¬¶øÖ»ÓÐÔÚÇ¿ÀàÐ͵ÄDataContextÇé¿öϲŻáÓеġ£ËùÒÔÖ»ÓÐÔÚÇ¿ÀàÐ͵ÄÇé¿öϲŻáÔÚ³õʼ»¯DataContextµÄʱºòÉèÖÃÕâЩTable<


Ïà¹ØÎĵµ£º

SQL SERVER 2005°²×°Íê³Éºó·þÎñºÍ×é¼þ½éÉÜ

SQL SERVER ·þÎñ
SQL Server Analysis Services £ºÎªÉÌÒµÖÇÄÜÓ¦ÓóÌÐòÌṩÁª»ú·ÖÎö´¦Àí(OLAP)ºÍÊý¾ÝÍÚ¾ò¹¦ÄÜ(ºËÐÄ·þÎñ)¡£
SQL Server Browser£º½« SQL Server Á¬½ÓÐÅÏ¢Ìṩ¸ø¿Í»§¶Ë¼ÆËã»ú
SQL Server FullText Search£º¿ìËÙ´´½¨½á¹¹»¯ºÍ°ë½á¹¹»¯Êý¾ÝµÄÄÚÈݺÍÊôÐÔ
SQL Server VSS Writer£ºÌṩͨ¹ý Windows VSS »ù´¡½á¹¹ ......

JAVAÖзÀÖ¹SQL×¢Èë¹¥»÷ÀàµÄÔ´´úÂë

package cn.com.hbivt.util;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2005</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class StringUtils {
//¹ýÂËͨ¹ýÒ³Ãæ±íµ¥Ìá½» ......

SQL ´¥·¢Æ÷Ïê½â

´¥·¢³ÌÐò£¨trigger£©ÊÇÒ»ÖÖÌØÊâÐÍ̬µÄÔ¤´æ³ÌÐò£¬µ±ÄúʹÓÃInsert¡¢Update»òDeleteÃüÁîÀ´ÐÞ¸Ä×ÊÁÏÁÐʱ£¬Microsoft SQL Server»á×Ô¶¯Ö´ÐÐÄúËù¶¨ÒåµÄ´¥·¢³ÌÐò¡£
       ´¥·¢³ÌÐò£¨trigger£© ÊÇÒ»ÖÖÌØÊâµÄÔ¤´æ³ÌÐò£¬Ö´ÐÐÌض¨µÄ³ÂÊöʽ£¨Update¡¢Insert »ò Delete£©¾Í¿ÉÒÔ啟¶¯´¥·¢³ÌÐò¡£´¥·¢ ......

SQL SERVER 2008 EXPRESS°æ±¾Ô¶³ÌÁ¬½Ó(tcp/ip)

´ËÎÊÌâÕÛÌÚ°ëÌì,googleÒ²ËÑË÷ÁË,ÍøÉϺܶàÅóÓÑÒ»°ã×öµ½µÚ¶þ²½²»³É¹¦,ÎÒÒ²²îµã·ÅÆúÁË.×îºóͨ¹ýµÚÈý²½Á¬½Ó³É¹¦ÁË.
1.·À»ðǽÔÊÐí1433
2.ÅäÖù¤¾ßÀïµÄSQL Server ÅäÖùÜÀíÆ÷.´ò¿ªºó,¿ªÆôÓÒ±ßÈý¸öЭÒé.²¢¶Ôtcp/ipÈçÏÂÅäÖÃ
 
3.ÍøÉϴ󲿷Ö×öµ½µÚ¶þ°æÖØÆôsql server·þÎñ,ÈÔÈ»ÎÞЧ.Æäʵ,ÐèÒªÐÞ¸ÄÁ¬½Ó×Ö·û´®.Ö¸¶¨ÎÒÃÇÅäÖõĶ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ