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.Location="inet4://localhost/d:\\database\\fb_03_0_0\\employee.fdb";
 
   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 of sample.
Output.