1 CREATE TABLE BK."Test"
2 (
3     "ID" NUMBER NOT NULL,
4     "Name" NUMBER NOT NULL
5 )

SELECT * FROM "Test";

 1   <oracle.manageddataaccess.client>
 2     <version number="*">
 3       <edmMappings>
 4         <edmMapping dataType="number">
 5           <add name="bool" precision="1" />
 6           <add name="byte" precision="2" />
 7           <add name="int16" precision="5" />
 8         </edmMapping>
 9       </edmMappings>
10     </version>
11   </oracle.manageddataaccess.client>

 1 namespace XXY.DbEntity
 2 {
 3     using System;
 4     using System.Collections.Generic;
 5     using System.Runtime.Serialization;
 6     using System.ComponentModel.DataAnnotations;
 7     using Newtonsoft.Json;
 8     
 9     
10     /// <summary>
11     /// 承运人运价表
12     /// </summary>
13     [Serializable,DataContract(IsReference = true),JsonObject(IsReference = false)]
14     public partial class PRICE
15     {
16         public PRICE()
17         {
18             this.PRICE_DETAIL = new HashSet<PRICE_DETAIL>();
19         }
20     
21         /// <summary>
22         /// 价格流水号  必填项
23         /// </summary>
24         [DataMember , Required]
25         public decimal PRICE_ID { get; set; }
26     
27         /// <summary>
28         /// 承运人流水号  必填项
29         /// </summary>
30         [DataMember , Required]
31         public decimal CARRIER_ID { get; set; }
32     
33         /// <summary>
34         /// 承运人代码  必填项
35         /// </summary>
36         [DataMember , Required, StringLength(30)]
37         public string CARRIER_CODE { get; set; }
38     
39         /// <summary>
40         /// 承运人名称  
41         /// </summary>
42         [DataMember, StringLength(200)]
43         public string CARRIER_NAME { get; set; }

1 public static decimal GetNextVal(this System.Data.Entity.DbContext ctx, string seqName) {
2     return ctx.Database.SqlQuery<decimal>(string.Format("SELECT {0}.NEXTVAL FROM DUAL", seqName)).First();
3 }
4 
5 public static decimal GetNextVal<T>(this DbContext ctx, T enumValue) where T : struct, IComparable, IConvertible, IFormattable {
6     return ctx.GetNextVal(enumValue.ToString());
7 }

 1 protected override bool ShouldValidateEntity(DbEntityEntry entityEntry) {
 2     UpperConverter.Convert(entityEntry.Entity);
 3     return base.ShouldValidateEntity(entityEntry);
 4 }
 5 
 6     internal static partial class UpperConverter {
 7         private static Dictionary<Type, List<PropertyInfo>> TPS = new Dictionary<Type, List<PropertyInfo>>();
 8         public static void Add<T>(params Expression<Func<T, string>>[] exprs) {
 9 
10             foreach (var expr in exprs) {
11 
12                 PropertyInfo pi = null;
13 
14                 switch (expr.Body.NodeType) {
15                     case ExpressionType.MemberAccess:
16                         pi = (PropertyInfo)((MemberExpression)expr.Body).Member;
17                         break;
18                     default:
19                         throw new InvalidOperationException();
20                 }
21 
22 
23                 if (TPS.ContainsKey(pi.DeclaringType))
24                     TPS[pi.DeclaringType].Add(pi);
25                 else {
26                     TPS.Add(pi.DeclaringType, new List<PropertyInfo>() { pi });
27                 }
28             }
29         }
30 
31         public static void Convert(object obj) {
32             var type = obj.GetType();
33             if (TPS.ContainsKey(type)) {
34                 var ps = TPS[type];
35                 foreach (var p in ps) {
36                     var value = (string)p.GetValue(obj);
37                     if (!string.IsNullOrWhiteSpace(value))
38                         p.SetValue(obj, value.ToUpper());
39                 }
40             }
41         }
42 }
43 
44 
45     internal static partial class UpperConverter {
46 
47         public static void Set() {
48 
49             #region 审核权限
50             Add<BOOKING_ORDER_PERMISSIONS>(p => p.CARRIER_CODE, p => p.LOADING_PORT, p => p.ROUTE_CODE, p => p.SHIP_CODE,
51                 p => p.VOYAGE);
52             Add<SPECIAL_PRICE_RULE>(p => p.CARRIER_CODE, p => p.ROUTE_CODE, p => p.SHIP_CODE, p => p.VOYAGE);
53             Add<SPECIAL_PRICE_RULE_CONTA>(p => p.SIZETYPE_CODE);
54             #endregion
55 …

 1 [AttributeUsage(AttributeTargets.Class)]
 2 public class AnnoationForAttribute : Attribute {
 3     public AnnoationForAttribute(Type type);
 4 
 5     public Type ForType {
 6         get;
 7         set;
 8     }
 9 }    
10 
11 public class AnnorationHelper {
12 
13     public static void AutoMap() {
14 
15         var types = typeof(AnnorationHelper).Assembly.GetTypes();
16         foreach (var t in types) {
17             var attr = (AnnoationForAttribute)t.GetCustomAttributes(typeof(AnnoationForAttribute), false).FirstOrDefault();
18             if (attr != null)
19                 TypeDescriptor.AddProviderTransparent(new AssociatedMetadataTypeTypeDescriptionProvider(attr.ForType, t), attr.ForType);
20         }
21 
22     }
23 
24 }  

1 [AnnoationFor(typeof(DbEntity.PRICE))]
2 public class PRICE {
3 
4     [CompareWith("EFFECTIVE_DATE", CompareWithOpts.Gt)]
5     public object EXPIRATION_DATE {
6         get;
7         set;
8     }
9 }

AnnorationHelper.AutoMap();

1 CREATE OR REPLACE function BK.ToString(P NUMBER) 
2 return VARCHAR
3 is 
4    V VARCHAR(10); 
5 begin 
6   select TO_CHAR(P) into V FROM DUAL; 
7   return V; 
8 end;

1 public static class OracleFunctions {
2     [EdmFunction("Model.Store", "TOSTRING")]
3     public static string ToString(decimal d) {
4         throw new InvalidOperationException("Not to be called from client code");
5     }
6 }