The official ClickHouse.EntityFrameworkCore NuGet package targets EF Core 10. I forked the official GitHub repo and compiled it for EF Core 11 / net11.0. Package version 0.4.0-ef11.
https://github.com/ZaferGokhan/ClickHouse.EntityFrameworkCore
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | /// <summary> /// IEnumerator , IQueryable ve diğerlerini HashSet e cevirir. /// </summary> /// <returns></returns> public static HashSet<T> ToHashSet<T>(this IEnumerable<T> Source) => new HashSet<T>(Source); /// <summary> /// IEnumerator , IQueryable ve diğerlerini Hashtable e cevirir. /// </summary> /// <returns></returns> public static Hashtable ToHashtable(this NameValueCollection source) { Hashtable _Hashtable = new Hashtable(); foreach (string key in source.Keys) { _Hashtable.Add(key, source[key].ToString()); } return _Hashtable; } /// <summary> /// Hashtable içerinde veri varmı diye bakar. /// </summary> /// <returns></returns> public static Boolean HashtableHasKeys(this Hashtable Source) => Source.Count == 0; |
Web.config
1 2 3 4 5 6 7 | <?xml version="1.0" encoding="utf-8"?> <configuration> <appSettings file="app.config"> <add key="webpages:Version" value="3.1.0.0" /> <add key="webpages:Enabled" value="false" /> </appSettings> </configuration> |
app.config
1 2 3 4 | <?xml version="1.0"?> <appSettings> <add key="ProjectVersion" value="02.00.0000"/> </appSettings> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | // RazorViewEngine Temizleniyor ViewEngines.Engines.Clear(); // Yeni bir RazorViewEngine Ekleniyor. İçeriği dolduruluyor. RazorViewEngine _RazorViewEngine = new RazorViewEngine() { FileExtensions = new string[] { "cshtml" } }; var ViewLocation = new string[] { "~/Views/{1}/{0}.cshtml", "~/Views/Shared/{0}.cshtml", }; _RazorViewEngine.PartialViewLocationFormats = ViewLocation; _RazorViewEngine.MasterLocationFormats = ViewLocation; _RazorViewEngine.ViewLocationFormats = ViewLocation; // TwoLevelViewCache Ekleniyor. _RazorViewEngine.ViewLocationCache = new TwoLevelViewCache(_RazorViewEngine.ViewLocationCache); ViewEngines.Engines.Add(_RazorViewEngine); |
1 2 3 | Nuget PM> Install-Package EntityFramework 6.2 PM> Install-Package MemoryCache |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | public class MyDbConfiguration : DbConfiguration { /// <summary> /// InMemoryCache Nesnesi oluşturmayı sağlar. Entity Framework Query Cache için bir adet eklendi. /// Nuget Install-Package MemoryCache Ekli olması lazım. /// </summary> public static InMemoryCache EntityCache = new InMemoryCache(); public MyDbConfiguration() : base() { // Entity Framework Query Cache Eklenmesi sağlanyan kod. CacheTransactionHandler TransactionHandler = new CacheTransactionHandler(EntityCache); AddInterceptor(TransactionHandler); Loaded += (sender, args) => args.ReplaceService<DbProviderServices>((s, _) => new CachingProviderServices(s, TransactionHandler, new CachingPolicy())); // Entity Framework Query Cache Eklenmesi sağlanyan kod. } } |
1 2 3 4 | Nuget PM> Install-Package EntityFramework 6.2 PM> Nuget Install-Package MemoryCache PM> Install-Package EntityFramework.Cache |
1 2 3 4 5 6 7 8 9 10 | public class MyDbConfiguration : DbConfiguration { public MyDbConfiguration() : base() { // App'in Çalıştığı yeri bulur string UIPath = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase).Replace("bin", "Documents\\Cache").Replace("file:\\", ""); // ModelStore Set Eder.. SetModelStore(new DefaultDbModelStore(UIPath)); } } |
1 | pm > Install-Package WURFL_Official_API |
Global.asax
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | public class MvcApplication : System.Web.HttpApplication { public const String WurflManagerCacheKey = "__WurflManager"; public const String WurflDataFilePath = "~/App_Data/wurfl-latest.zip"; protected void Application_Start() { AreaRegistration.RegisterAllAreas(); FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters); RouteConfig.RegisterRoutes(RouteTable.Routes); BundleConfig.RegisterBundles(BundleTable.Bundles); var wurflDataFile = HttpContext.Current.Server.MapPath(WurflDataFilePath); var configurer = new InMemoryConfigurer() .MainFile(wurflDataFile); var manager = WURFLManagerBuilder.Build(configurer); HttpContext.Current.Cache[WurflManagerCacheKey] = manager; } } |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 | public class BaseController : Controller { public class WhiteSpaceFilter : Stream { private Stream _shrink; private Func<string, string> _filter; public WhiteSpaceFilter(Stream shrink, Func<string, string> filter) { _shrink = shrink; _filter = filter; } public override bool CanRead { get { return true; } } public override bool CanSeek { get { return true; } } public override bool CanWrite { get { return true; } } public override void Flush() { _shrink.Flush(); } public override long Length { get { return 0; } } public override long Position { get; set; } public override int Read(byte[] buffer, int offset, int count) { return _shrink.Read(buffer, offset, count); } public override long Seek(long offset, SeekOrigin origin) { return _shrink.Seek(offset, origin); } public override void SetLength(long value) { _shrink.SetLength(value); } public override void Close() { _shrink.Close(); } public override void Write(byte[] buffer, int offset, int count) { // capture the data and convert to string byte[] data = new byte[count]; Buffer.BlockCopy(buffer, offset, data, 0, count); string s = Encoding.Default.GetString(buffer); // filter the string s = _filter(s); // write the data to stream byte[] outdata = Encoding.Default.GetBytes(s); _shrink.Write(outdata, 0, outdata.GetLength(0)); } } protected override void OnActionExecuting(ActionExecutingContext Context) { var request = Context.HttpContext.Request; var response = Context.HttpContext.Response; response.Filter = new WhiteSpaceFilter(response.Filter, s => { s = Regex.Replace(s, @"\s+", " "); s = Regex.Replace(s, @"\s*\n\s*", "\n"); s = Regex.Replace(s, @"\s*\>\s*\<\s*", "><"); s = Regex.Replace(s, @"<!--(.*?)-->", ""); //Remove comments // single-line doctype must be preserved var firstEndBracketPosition = s.IndexOf(">"); if (firstEndBracketPosition >= 0) { s = s.Remove(firstEndBracketPosition, 1); s = s.Insert(firstEndBracketPosition, ">"); } return s; }); } } |
Hata:
Managed Debugging Assistant ‘LoaderLock’ has detected a problem in
1 2 3 | Managed Debugging Assistant 'LoaderLock' has detected a problem in 'C:\Users\zafer\Desktop\RunJoyStickOnLocalMachine\RunJoyStickOnLocalMachine\bin\Debug\RunJoyStickOnLocalMachine.vshost.exe'. Additional information: DLL 'C:\WINDOWS\assembly\GAC\Microsoft.DirectX.DirectInput\1.0.2902.0__31bf3856ad364e35\Microsoft.DirectX.DirectInput.dll' is attempting managed execution inside OS Loader lock. Do not attempt to run managed code inside a DllMain or image initialization function since doing so can cause the application to hang. |
Çözüm:
“Debug > Windows > Exception Setting > Managed Debugging Asistants > LoaderLock” Check’ini kaldırın.
Bir projemizde joystick kullanmamız gerekiyordu.C# ta joystick komutları nasıl alırım diye araştırmaya başladım. CodeProject birkaç başrısız örnekten sonra Mostafa Korashy ‘in bir örneğine rasladım. Ama bazı tuşların çalışmadığını gördüm. Bu uygulama üzerinden geliştirme yaptım.