Publish date: 2017-11-14
Connection to database from .NET Core application. (C#, FB)
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 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 | //////////////////////////////////////////////////////////////////////////////// //Example for "LCPI ADO.NET Provider for OLE DB" // LCPI. 14.11.2017 using System; using System.Threading; using xdb=lcpi.data.oledb; namespace Sample_0001.vs2017{ //////////////////////////////////////////////////////////////////////////////// //class Program class Program { static void Main( string [] args) { try { Console.WriteLine( "Initialization of COM [MTA] ..." ); Thread.CurrentThread.SetApartmentState(ApartmentState.MTA); var cnsb= new xdb.OleDbConnectionStringBuilder(); cnsb.Provider= "LCPI.IBProvider.3" ; cnsb.UserID= "GAMER" ; cnsb.Password= "vermut" ; cnsb.IBProvider.dbclient_type= "fb.direct" ; using ( var cn= new xdb.OleDbConnection(cnsb.ConnectionString)) { Console.WriteLine( "Connection to database ..." ); cn.Open(); var ds_info=cn.GetSchema(xdb.OleDbMetaDataCollectionNames.DataSourceInformation); Console.WriteLine( "" ); var R0=ds_info.Rows[0]; Console.WriteLine ( "DBMS Name : {0}" , Helper__ValueToStr(R0[xdb.OleDbMetaDataCollectionColumnNames.DataSourceInformation.DataSourceProductName])); Console.WriteLine ( "DBMS Version: {0}" , Helper__ValueToStr(R0[xdb.OleDbMetaDataCollectionColumnNames.DataSourceInformation.DataSourceProductVersion])); Console.WriteLine( "" ); Console.WriteLine ( "OLE DB Provider Descr : {0}" , Helper__ValueToStr(R0[xdb.OleDbMetaDataCollectionColumnNames.DataSourceInformation.LCPI_OleDbProviderFriendlyName])); Console.WriteLine ( "OLE DB Provider File : {0}" , Helper__ValueToStr(R0[xdb.OleDbMetaDataCollectionColumnNames.DataSourceInformation.LCPI_OleDbProviderFileName])); Console.WriteLine ( "OLE DB Provider Version: {0}" , Helper__ValueToStr(R0[xdb.OleDbMetaDataCollectionColumnNames.DataSourceInformation.LCPI_OleDbProviderVersion])); Console.WriteLine( "" ); Console.WriteLine ( "ADO.NET Provider File : {0}" , cn.GetType().Assembly.GetModules()[0].Name); Console.WriteLine ( "ADO.NET Provider Version: {0}" , cn.GetType().Assembly.GetName().Version); } //using cn } catch (Exception exc) { Console.WriteLine ( "ERROR: {0} - {1}" , exc.Source, exc.Message); } //catch Console.WriteLine( "" ); Console.WriteLine( "Force release of references to COM objects" ); GC.Collect(); GC.WaitForPendingFinalizers(); } //Main //---------------------------------------------------------------------- private static string Helper__ValueToStr( object v) { if (Object.ReferenceEquals(v, null )) return "#EMPTY" ; if (DBNull.Value.Equals(v)) return "#NULL" ; return v.ToString(); } //Helper__ValueToStr }; //class Program //////////////////////////////////////////////////////////////////////////////// } //namespace Sample_0001.vs2017 |

Output.